Sanitize MS Office Files - Add Fixed Data to Meta Data Fields

Help & Support
1

Hello All,

Looking for a button and right click option to

  1. Sanitize MS Office files by removing all data in the meta data fields (making them blank). Example from below screenshot fields in excel file.

RHhxW6l3jV
RHhxW6l3jV360×503 23.9 KB

4rE5mf6Q2E
4rE5mf6Q2E363×507 25.7 KB

  1. Another option to erase and replace any existing meta data and put standard pre-defined data in the selected data fields (for example to personalize the file with my own information). The meta data fields to be affected can be selectable in this case, same from the above screenshots , the usual fields which have some data values.

Pardon if this is asked before, i wasn’t able to find much info about it.

Thanks for your guidance and solutions.

2

Clicking the link in the dialog will create a copy with personal information removed.

Opus can also remove metadata, though it may not catch everything. Use the following command:

dopusrt /cmd SetAttr FILE={filepath} META *

Alternatively, ExifTool can handle metadata removal as well:

exiftool.exe -overwrite_original -verbose -progress: -all= -@ {allfilepath|filem}

To write metadata, use the SetAttr command. For Office-specific fields, you'll need a script that interacts with the Office object model. This is relatively straightforward to implement.

3

I have not tried to create a DOpus script, although using SetAttr | Metadata Pane F9 works pretty well. Also you could investigate AttributeMagic-Pro to set metadata fields using ‘templates’:

you’ll see it has not been updated since May 2012, but it works fine on MS DOCX, etc. files.