Once read in, the XML strings can be manipulated with the stock VBA string functions like InStr(), Replace(), Mid(), and so on. See for more info on reading UTF-8 strings. This will become clear once you have an accented character, Cyrillic name, or Kanji as an author. UTF-8 is not directly supported by VBA, however works fine when read with ADO. Be sure to unzip the files in the standard Microsoft location. dotx file does not need to be renamed, and you can selectively extract the various XML files without unzipping the whole thing. In the end you will have certainly achieved coder status once you get this to work.Īs suggested by 7-Zip is my preferred compression tool to be used with VBA. It's a lot of work compared to just changing the name of the author who made the revision using the Word object model, which naturally does not work at all. The Edit Open XML procedure described in post can be reliably automated in VBA. In the "Compare Documents" dialog, navigate to and select V1 as the original document, and then V2 as the revised document type the desired author name after “Label changes with” after “Show changes in,” select “New document,” then click OK. Open V1 in Word > Review tab > Compare > Compare. Save another copy of the original document, name it V2, and accept all changes in it. Save a copy of the original document, name it V1, and reject all changes in it. The following method uses Word compare to set the author of all revisions to a specific author (however, be aware that this method generates completely new revisions that might (slightly) differ from your original revisions):
#WORD FOR MAC 2016 CHANGE XML FILE ZIP#
#WORD FOR MAC 2016 CHANGE XML FILE PC#
Here's my code, which I unfortunately can't test as my work PC has authors locked as a security policy.
I think I have a solution, which conceptually works by taking all revisions with a specific author, storing them in collections, rejecting them in the body of the selection, changing username, then re-implementing the changes as new amendments to the document (thus creating new revisions with the new author). I am a near-complete novice at coding of any sort but a pretty quick/intuitive study and I've been hacking away at this problem as one of my first projects. NOTE: This is a very old question but this seems to come up A LOT from googling and no-one has provided a solution here or anywhere else, so I am adding mine.
0 kommentar(er)
