ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Detect when Word document is updated (https://www.excelbanter.com/excel-programming/425787-detect-when-word-document-updated.html)

Alan[_8_]

Detect when Word document is updated
 
I have a Word document that has links in it to pull data from
an Excel spreadsheet to populate the document. There is a lot of
data, and this takes a while.

Is there a way with VBA code in Excel to detect when the Word
document is completely updated?

I do other, related proecssing in Excel with VBA code, and
knowing about the completed update to the Word document would be used
to kick off subsequent processing (e.g., printing the Word
document).

Or is this part best done with VBA in the Word document?

Thanks, Alan



All times are GMT +1. The time now is 04:16 PM.

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