![]() |
#1
|
|||
|
|||
![]()
A Word document functions as a kind of engineering drawing that has to be updated from time to time.
To keep a track on these updates a parallel document serves as a log where the changes are described, and to make sure it is filled in every time changes are made, I have an AutoClose macro in the drawing document automatically open the log document. I should like to make it so, that the log is opened only if changes have been made to the drawing document, but I do not know how to detect that in VBA. Anyone has a clue? NSV |
#2
|
||||
|
||||
![]()
Simply use Track Changes in the document. That will record all changes, including who made them an when (unless the user turns Track Changes off).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
I do not want to switch on Track Changes; what I need is VBA access to the same 'flag' that prompts the program when closing down to ask if I want to save changes - if such a 'flag' exists.
I am looking for a 'DocumentChange = True' or something like that. NSV |
#4
|
||||
|
||||
![]()
You can test the Saved state (e.g. If 'Document.Saved = False') to tell you whether the document has been edited but, unless you're doing some form of before/after comparison, you'll have no way of knowing what those changes were. And, unless you trap all saves as well, testing the Saved state won't even tell you whether the document was changed while it was open.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
![]()
OK, I see.
I was hoping for something that could tell me if changes had been made within the session, regardless of the document having been saved, but I see that it is not possible. Thanks for your help. NSV |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ayeh | Project | 14 | 02-12-2014 10:41 AM |
Detect a cell has un-approved change or not? | LongTTH | Excel Programming | 1 | 05-20-2012 02:22 AM |
auto-detect display options? | davidt76 | PowerPoint | 0 | 09-30-2011 07:26 AM |
![]() |
Karin | Excel | 1 | 03-04-2011 12:56 PM |
What slide attribute can I use in VBA to detect hidden slide? | mikel401 | PowerPoint | 1 | 02-22-2011 11:13 AM |