ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Activate Object question (https://www.excelbanter.com/excel-worksheet-functions/169656-activate-object-question.html)

Eva

Activate Object question
 
I have the spreadsheet where I keep my analysis. We need to create reports in
PDF, so I pasted object €“ Excel spreadsheet into Ms Word and linked there my
data to Excel spreadsheet. The problem is that for some reason Ms Word
doesnt want to update links automatically, so I need to double click on
objects and then it updates it.
So I need a macro that will go over all objects in MS Word and activate them
only (so all links will be updated)
But I am not VB expert, so I tried and I god error messages. I really
appreciate if you can help me
Eva



All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com