Excel VBA: Generating Word file [embedded?]

[Narozsnikz]

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?

[Narozsnikz]

OKay Im trying to figure it out. This code does the trick with some flaws.

Please Login or Register  to view this content.

Obejktum 2 is the embedded word file.

The problem is, that this code overwrite the embedded word and not making a new one. So if I change something and generate the word again it will be a total mess of the previous and with the new data.

Any ideas? How to make that the embedded word remain just the CORE and INTACT?

Thanks

[Narozsnikz]

No one?

[macropod]

The simplest solution would be to store a Word template in a folder all users are given access to. What you haven't explained, though is how users can get access to the Excel workbook, but not the Word file. If you're achieving access by distributing the Excel workbook, why are you not distributing the Word document with it?

Alternatively, you could have your code save the embedded Word file to whatever folder the Excel workbook is stored in, then access it (not the embedded version) in the normal manner.