I have a project that needs to do the following once a quarter and will involve 200+ documents each time so I'm looking for a semi-portable solution.
1. Set the document properties in a standardized fashion.
Each document follows a strict template so I will be able to open the file, "scrape" the data I need, re-format it for the properties, set the new properties, save and close the file.
I propose the following using VBA code:
(simplified for brevity)
1. open the file
2. do a search in the file for a person's name (Instr, Mid, etc.) (always located in the same place)
3. re-format the name (Last, First M.) set that name into the title property
4. save file
5. close file
I'm looking for specific code and am open to a whole new proccess, this is what i've come up with so far....