aerotek1234
11-10-2014, 12:54 PM
My company was just bought out and we would like to update all of our SOPs to include the new company name and the new company logo. I was wondering if someone could help with a macro to do this.
Additionally we like the Rev field to be updated to whatever the current rev is to a xxx.ADMIN1. Also, have the current date replace the current typed/revised date. Lastly, have a new page created with some common text saying an administrative change has been made.
I attached a sample document so you can see what I am generally working with. One other interesting thing is that there may be several versions of the past company name. Would it be easier to run multiple Macros or can one Macro change various company names to the new one. There are quite a few documents that I would want to run the Macro on.
Thanks
Additionally we like the Rev field to be updated to whatever the current rev is to a xxx.ADMIN1. Also, have the current date replace the current typed/revised date. Lastly, have a new page created with some common text saying an administrative change has been made.
I attached a sample document so you can see what I am generally working with. One other interesting thing is that there may be several versions of the past company name. Would it be easier to run multiple Macros or can one Macro change various company names to the new one. There are quite a few documents that I would want to run the Macro on.
Thanks