Search results for query: *

Macropos said, "... you'll need to take a different approach. For example, you could copy the reference cell, find the relevant location in the Word document and paste the cell's contents there as formatted text. " Yes... This is what I need, how do I do this? -Jason

Thanks macprod, I may have something else in the code wrong, but this code does not seem to work. I am getting a runtime error 94 - (Invalid use of Null). Ital = .Font.Italic is highlighted. Any help would be great. -Jason

One more issue... If anyone knows how to include the footnotes / endnotes, it would be much appreciated. -HQ

Thanks for the reply. I like the idea, but cannot get it to work. I received a runtime error 424 at: wrdSelection.Find.Text.Font.Bold = .Cells(row,2).Font.Bold Here is the full code: Sub Replace() ' to test this code, paste it into an Excel module ' add a reference to the Word-library '...

I have set up some code to search and replace data in my word files based on excel columns. IT works ok... (although I get a small erroe at the end.. Anyway, what it does not do, is preserve the formatting in the excel spread sheet. For example, I have colored text / italics in my excel...