VBA copy to word, but do not delete bookmarks

Hi all,

I currently have 2 x codes to copy data from an excel spreadsheet into a word template when a command button on a userform is selected. The two codes are to paste text and pictures.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Currently once the codes have been run and the word document is produced I save it somewhere and then if I need to do it again with different data, I have to delete the original word template and replace it with a master copy, as the bookmarks are deleted.

Is there a way of getting around this? I.e. not deleting the bookmarks?

Hi chrisellis,

Try save as (to another location or/and another name) instead of save overwrite the template. If you don't save the template during running macro, the template will be not changed.

Save as seems like a perfect solution. How would I go about saving as a file name as per a particular cell and then defining the location for the save?

The Procedure1 may be look like this:

Please Login or Register  to view this content.

Thank you for your code. Although there are no issues with it, it does not work with procedure 2 as the word document is then saved as a name not recognised by procedure 2.

I have amended the code slightly to save the word document elsewhere and then procedure 2 is able to carry on.

However, I am looking at a way to then save the file as a particular name from procedure 2 - once everything has been saved into the document. If you understand what I mean?

I had showed to you the method to save as with specific name
I don't know what is your problem. Please clarify.
Note that some characters are not allowed to naming a file.