I have a word doc with a macro that will search all files in a folder and strip the SSN's from the files (Thanks, macropod!). Now, to make this operation as simple as possible for my customer, I would like to set it up so the macro (VB) is saved to a specific document not globally (I have this part done). What I need help with is configuring that macro to run automatically when the file is opened. End goal is for the customer to open the word doc containing the macro and it auto runs instead of them having to navigate through Word to View/Macros/select and run the macro. I would also like for the word doc to close when the macro is finished running. It will be much easier to distribute the doc with the embedded macros than to instruct each customer how to import the macro.

The script is avail here if needed: https://www.msofficeforums.com/word-...in-folder.html