Linking a Word File to an Excel File

[alexkeel79]

I'm looking for a way to link a WOrd file to an Excel File. Basically what I have is an excel file which tracks 8 fields for certain issue #'s. Then I have a word file that has some additional information on these issues. I would like to set it up so that the word file references the fields that are in the excel file and updates with the execution of a macro. Is there a way to do this?

 

[fumei]

Yes. But you have to spec this out in more detail.

Where is the macro executing? In Word (checking into the Excel file to update itself?), or in Excel (with changes that will update to Word?)

What actually will cause the macro to execute?

Gerry