Hi Experts, I have about 50,000 word documents sitting on a file server as part of an application that I support. There was an issue where some of the files - no telling how many - we're saved with track changes on and unaccecpted changes to the document (I.e., the red text). I need to write a program that will examine each file and determine if A) track changes is enabled, B) if there are any unaccecpted changes, C) when the file was last modified, D) who modified it.
I'm thinking that this information is stored in the metadata of the file somewhere, or at least in the file properties. I believe a batch program would be the easiest way to do this with the output going to a .txt or .csv file. I would actually be more comfortable if there were a VBA program that I could run out of Excel that could do the analysis ( I'm pretty good with VBA)
Any suggestions would be much appreciated - I'm in kind of a crunch here.