View Single Post
 
Old 05-30-2023, 11:43 AM
eastsidedfw eastsidedfw is offline Windows 10 Office 2016
Novice
 
Join Date: May 2023
Posts: 2
eastsidedfw is on a distinguished road
Default Macro footer formatting Doc A to Doc B then Headers

Hey there you guys! I SURE hope you can help me.

We have a bunch of older ISO certification documents - they use the old branding and I've been asked to update them. Problem is, there's like 600 documents.

What i was hoping to do is create a macro that will update all of these.

The parameters are as follows:

Word Document A has a new header and footer with the proper formatting.

For this example, we will reference the secondary doc as Word Document B

Word Document B has old header and footer BUT the information from the header text needs to be retained. It's an ISO doc so there's a version, revised by, revision date etc that needs to be kept.


In the new version in Word Doc A all of the information in the header of Word Doc B has been moved to the footer.


So, what I would like to do is:
  1. Create a Macro that
  2. Takes footer formatting from Word Doc A and moves it to Word Doc B
  3. Using the text/copy content from Word Doc B Header
  4. and Replace Header in Word Doc B with the Header version from Word Doc A.

How do I go about this you guys? Is this a VBA thing or is this regular macro functionality that will work by just taking the time to map it all out in the recorded macro?

I am so grateful for any direction or insight you can provide me!! Haven't done a macro in a reallllllllllllly long time.
Reply With Quote