Hello!

I have a complete excel file which runs a lot of macro and VBA. One of the functions is generating a word file from the results. Now its calling a previously made word file, which has all other text and graphics in, and with bookmarks the excel vba is integrate the datas and tables in it, and save it as another word file in the same directory where the excel is.

Now the problem is;

This excel file is used by many people and not everyone has proper access to the starting word file (which is now on a NAS). Because of this, creating a new word file has problems from time to time.
I thought excel could, embed and store the original word file, but I didn't find a solution how I could access and use bookmarks in vba in the same way as before.
The second variation that came to my mind is that there would be no starting word file at all, all the data would be generated from the excel but in this case the problem is how I put the company header and logos in the generated word file?

So the end result should be one excel file which works the same as before and would not call the the WORD file from the NAS.

Do you have any ideas for this, which solution would be a good way to do this?