Hello to all,
I'm an Excel and Word user but not used to use macro or vba programming (don't have any ability on these fields).
I'm looking for a solution for the following problem : I'd like to generate a dynamic Word document (which would be based on a template) depending on the content of an Excel document.
What I'm looking for for instance is to be able to generate a document like this :
I) first information on the first line of Excel
content_of_the_other_first_line_cells would compose the content of this
II) first information on the second line of Excel
content_of_the_other_second_line_cells would compose the content of this
...
And the Word document would thus be generated depending on the content of this Excel, and would allow me to generate any new Word document using the same template just by modifying my Excel file, so it would probably don't have the same number of titles depending on the content of this Excel file.
I tried to use "mailing" fonction in Excel but it only allows me to create fixed documents without the possibility to have a dynamic document.
My idea was to loop through this Excel list and to always have the same treatment on the line (generating the title then the content depending on the contents of the line... and so on). But I'm stuck at this point because I don't know how to do this using either basic Excel/Word fonction or VBA.Maybe macros would make the point too.
Any clue or solution ?![]()
![]()
Bookmarks