Excel to Word - VB

Hi,

Having search numerous posts and forums I am unable to find a solution and starting to wonder if it is even possible, so if you know the answer please help!

Currently I have an excel document that produces analysis and a word template ... macro then takes the desired data from excel and populates to predefined bookmarks within word. The final stage of my report requires me to populate the word document with individuals statistics, each individual should have their own page within the word document ... the number of individuals and their assets will change with each report run as report is determined by parameters set by the initiator.

I am after code that will allow me to loop through the list of individuals in report, then create a bookmark for each individual in my word template.

The below doesn't work / is mock script ... but hopefully it helps describe what I am trying to achieve:

Please Login or Register  to view this content.

... the above would then give me the required amount of bookmarks, 1 per line ... hope that makes sense?

Any help is greatly appreciated!!

Thanks

Ben

Hi AlphaFrog and thank you for taking the time to comment!!

I have literally just solved my problem ... see the following:

Please Login or Register  to view this content.

As the report will increase and decrease in the number of individuals contained within the report, I needed a solution that would only create the required number of bookmarks per number of tables produced from my report.

In answer to your question, each book mark needed to be placed at 'the end' of the document. I then nested the above script in a loop to create book marks for the dynamic list of individuals.