Posts by lejack02

    Hi everyone,

    I'd like to do through VBA the following thing: fill-in data from a database to a template. The challenge here is that the columns names from the database and the template fields are not similar (and that cannot be changed unfortunately). I've then created a correspondance table:

    Règles de remplissage
    Catégorie formulaire -> Colonne base de données correspondante
    Numéro d'étudiant -> [ID E]
    Nom de l'étudiant -> [N.E] - [P.E]
    Degré actuel -> [CL]
    Corps d'étude -> [Spec]

    I have to create about 600 templates automatically so I don't see any other solution than VBA. Each template would then be saved in a separated folder with the student ID as a filename.

    Does anyone know how to make them correspond and fill in automatically? I did it few years ago BUT the names were the same but now I'm completely blocked...I attached the file.

    A massive thank you to anyone who will provide me support !!