Microsoft Excel and Microsoft Word | Transferring Data

[gduron]

Hi,

I'm not sure if there is a better forum for this but I have a question about updating a report typed in word with values in an Excel Spreadsheet. I have a workbook that I use often and then I need to write a standard report that uses values from the changing workbook.

I would like to know if there is a way to create tags in the word document and then somehow write some code that would change the tags to the correct information.

The man lived in a house in <CITYNAME>.

The example here is very brief and I would have multiple tags to update. Any help would be greatly appreciated.

Thanks in advance.

 

[Gates Is Antichrist]

This only time I did this I relied heavily on this to get started; it has good clean code and discussion.

I'm sure others have other ways to do OLE links or mail merges or something else but this is one option. This way involves using VBA, and if you're okay with that, that's a great place with simple straightforward examples to learn how to code it.