Push cell value from Excel to bookmarks in Word

Hi.

I've found two sets of code that does what I need Excel to do. My problem is to combine the sets of code to operate as one.

The sub I'm trying to get a Excel VBA macro to run:

- Open my Word template file wich contains predefined bookmarks
- The Word template must be saved with a new filename equal the value of a cell in Excel combined with additional text, plus the extention .docx, because of multiple users
- Cell values from Excel linked in the macro pushed as text into the newly created *.docx Word document
- Leave the Word document open
- MsgBox in Excel when the push to Word is finished
- Another MsgBox if process fails.

Here is the combined sets of code. When I run it, it fails:

Please Login or Register  to view this content.

Anyone?

Thanks?

TJ

Please use the code tags. Read through the forum rules by clicking on link at the top of the page.

How/where does the code fail?

PS Are you sure you want to open the template itself? Don't you want to create a new document based on the template?

This will compile and run.

Please Login or Register  to view this content.

Thread posted in Commercial services, hence closed.