Word VBA >> Track changes via VBA

by Sm9oYW5uZXMgU3R1ZXJtZXI » Tue, 13 Jul 2004 08:33:03 GMT

Is is possible to invoke the command "Accept all" in the "Track changes" menu programmatically with VBA?

Thanks


Word VBA >> Track changes via VBA

by Word Heretic » Tue, 13 Jul 2004 10:06:58 GMT


G'day Johannes,

ActiveDocument.AcceptAllRevisions

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Johannes Stuermer reckoned:





Word VBA >> Track changes via VBA

by Sm9oYW5uZXMgU3R1ZXJtZXI » Fri, 23 Jul 2004 09:57:03 GMT

Thanks!





Similar Threads

1. Track changes via VBA

Is is possible to invoke the command "Accept all" in the "Track changes" menu programmatically with VBA?

Thanks

2. Accessing Tracking Status in a Custom Form via VBA - Microsoft Office Outlook

3. How to make "strikethrough" work via Tools/Options/Track Changes

I'm sharing a document with other writers. I cannot do "strikethrough" via 
the Fonts tab; it messes up everyone else's fonts. How can I use 
"strikethrough" on copy I want to "cut" by going through the 
Tools/Option/Track Changes channel?

4. Excel VBA: How to track changed cells - Excel

5. printing track changes with vba

if the track changes feature is turned on for a workbook,
is it possible to detect this using vba, and then to either print the 
tracking information (in a similar way to the feature to print comments
embedded on the worksheet), or using vba, to retrieve all the tracking
info - and print it manually?

tia,
dk

6. Using VBA to track workbook changes - Excel

7. Re-write "track changes" of Excel in VBA

I'm trying to rewrite a sort of the "track changes" feature of Excel using 
VBA.
The method I'm following is to store in a variable the value of the active 
cell/range every time the application event "selection change" is triggered.
Then I compare changes versus the previous stored variable when the 
application event "sheet change" happens, and so write eventual changes in 
formulas/values to a separate worksheet.

The procedure above seems to work fine when changing the values into cells 
using "normal" methods like just writing the new value into a cell or 
copying and pasting even complex ranges (not just single cells).

However, I noticed it doesn't work when using the autofill method: dragging 
(or double clicking) the small dot at bottom right corner of the selection 
marker.
This is due because in this case the "change" event is triggered BEFORE the 
"selection change" event is triggered, and not after as in "normal" methods. 
So in this case the application cannot store the values/formulas the cells 
had before they were changed, thus the application think no change happened.

I wonder whether there's a complete different way for doing that, like 
having a method of the range object that is passed to the "Change" event 
that stores the value/formula the range had before the change.

That's the SheetChange event declaration I'm using. Maybe I'm missing 
somthing?
Private Sub App_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Do you have any idea for solving the above issue?
Many thanks for your help.

Paolo
Milan, Italy 


8. Highlight Track Changes with VBA Code? - Excel