ajcourtney
New Member
- Joined
- Apr 22, 2016
- Messages
- 5
It seems that most of these situations involve linking Excel data to a Word doc. I'm doing the exact opposite: I have a letter in Word that I update monthly that needs to be linked to many Excel workbooks.
This is Excel 2010 BTW...
I can embed the object into each appropriate worksheet in these workbooks (making sure I choose Object ->Create from File->browse to the correct file on the network, and then check the "Link to file" checkbox), but changes made to the Word document are not reflected after running the VBA code in each workbook via the AutoOpen feature.
I'm guessing something in my existing code is breaking the updateremotereferences command (or perhaps I'm not using it correctly). Checking the "Update links to other documents" under Excel's advanced options is not really an option because it's not just one workbook - it's potentially 100's. And I'm guessing every time a new workbook would be created, someone would have to remember to check that option for that new workbook. I did suppress the update links warning dialogue box through the advanced options in Excel, though.
If I use ThisWorkbook.UpdateRemoteReferences = True, I get a distorted (stretched) giant icon of the OLE object instead of the text after the sheet is printed as a PDF. Weird. If I rem out the command, I get the Word document correctly minus the most recent changes.
Any ideas?
This is Excel 2010 BTW...
I can embed the object into each appropriate worksheet in these workbooks (making sure I choose Object ->Create from File->browse to the correct file on the network, and then check the "Link to file" checkbox), but changes made to the Word document are not reflected after running the VBA code in each workbook via the AutoOpen feature.
I'm guessing something in my existing code is breaking the updateremotereferences command (or perhaps I'm not using it correctly). Checking the "Update links to other documents" under Excel's advanced options is not really an option because it's not just one workbook - it's potentially 100's. And I'm guessing every time a new workbook would be created, someone would have to remember to check that option for that new workbook. I did suppress the update links warning dialogue box through the advanced options in Excel, though.
If I use ThisWorkbook.UpdateRemoteReferences = True, I get a distorted (stretched) giant icon of the OLE object instead of the text after the sheet is printed as a PDF. Weird. If I rem out the command, I get the Word document correctly minus the most recent changes.
Any ideas?