Smart way to create a standard Word Report with Excel data (Bookmarks?)

I have for quite some time now been looking into finding a way to create a standard Word Report that i will be using over and over, with data from various excel sheets. The layout of the report is predefined, however at different locations in the report
i need figures/tabels/data/text to be changeable, based on what project i am working on.
Initially i thought the "Paste Special, As link" feature could be the solution but after trying to make it work for quite some time, i've given up on that, as it keeps messing up my documents and breaking links for no apparent reason.

So then someone suggested i tried using Bookmarks to define where i want to input text/figures to Excel.

To some degree this is working in the sense that i have created a VBA modul that enables me to copy data from Excel to a specific point in the Word report (Predefined Bookmark) - However after the data is copied, i can't figure out a way to enable me to change the text that i now have in my word document, in case there is changes in the excel document. Essentially its a one-time transfer solution.

Essentially i want to end up with something where i have a Word Document with a Macro button in it i can press, which will check for all the bookmarks i have defined, and update their values, based on the current values of the excel sheets that they are retrieved from.
Can i do that with Bookmarks?

Or should i try and go in a different direction?

Thanks,
Nicolai

Thanks Cytop,

it definitely looks interesting and might prove to be my solution. Initially I ll just try and get the copying of single excel cells into the word documents as bookmarks to work. Then I ll work with the tables and figures afterwards.

I have made a code to copy a cell from excel into word (from a word VBA):

Please Login or Register  to view this content.

So essentially I open an excel document at a given path, I copy the value from cell A1 and the content of this cell is what I want to use in the bookmark named "Test1".
Can you point me in the right direction in terms of combining this with the bookmark macro you linked?

Thanks,
Nic

A slight rewrite - my original ran in Excel and updated Word. Changed to run in Word and start Excel, load a workbook and update from that. It still assumes the ActiveDocument is being updated.

Please Login or Register  to view this content.

Works like a charm!
Thank you.

I added:

Please Login or Register  to view this content.

at the end of the macro, aswell as adding to "This.Document" in my VBA project:

Please Login or Register  to view this content.

To ensure that Users cannot change my Bookmarks.

Thanks alot for your help.