How to Generate a Word document, using VBA, and using part of the data on excel?

do you have a template setup or do you need to use a new blank word document? (template as in a pre-format word document)

I have a template already set up, I want Excel to open it from a specific location and save it with a new name based on a combination of 2 cells value.

I am not sure if this can be done

yes it can be done, did you set up the template with either bookmarks or some sort of marker that we can use to correctly place the data?

well if i give you something to start with, do you think you can follow along and give it a go? its quite simple to do, but it probably will require a little tinkering about with the template...

you could place this on a button sub or call it from a button sub, either way

I'm not going to loop anything here, I'm assuming there are a manageable amount of bookmarks that we will use so we will just access them all one at a time to keep things easy.

Please Login or Register  to view this content.

ok this is the basic code to get you started.......aall you need to do it tie up the data in excel to the bookmarks in word.

just post back if it has problems i didnt test this. but it should be fine

Oh, also note that the bookmarks on the saved document will be removed, this is normal for the method i used to add the text to the document, if you want to keep the bookmarks on the saved file we need to edit the code a little