Hey everyone,

I have an excel macro that opens a word document with tracked changes, looks for certain values and then replaces them with other values from the excel document. However, with tracked changes, anything deleted or replaced is still retained in the word document and will be picked up by the Find object. I want to make a simple if clause to check if anything found is a revision or not, but I after spending days of searching I haven't been able to find anything that works.

I have played around with the Revisions object and while I can successfully count the number of revisions, everything else just gives me an error. Is it somehow possible to determine if the value found with wdDoc.Content.Find is a revision or not?

Any help would be greatly appreciated.