VBA Modify Text in Embeded Word Document through Excel Macro

[amyhasquestions]

Hi,

I have an embedded word document that I want to have references to the cells in the worksheet.

How can I write VBA code that updates the text values in the embed document using the cell value. Or references the cell value in the embed document.

If this is no clear, I want to have cell references in my embed word doc object. Or have a macro that goes through each embed word doc and updates based on cell value. I tried the macro recorder, but it only creates the object being created, not any modifications I make inside the embed object.


Thank You so much for your help!!!

Amy