Word page numbers incorrect after combining documents

Eagle72

New Member
Joined
Apr 5, 2005
Messages
21
Hi,
After combining several Word documents into one master document using VBA from Excel, I find that some of them automatically restart the page numbering that I have in the master document footer. The master document is created using a template that has a footer showing the page numbers. Is there a command that I can use to make sure that the page numbering of all sections that are brought in continue from the previous section? I find I can't even manually highlight the entire finished Word document and correct the page numbering. Also, the Word document template has a watermark set. Sometimes that will get removed after a certain document is inserted into the master document. I'd also love a solution for that problem.
Thanks.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
I should have put the versions of my software in my original post. I am running Office 2003. I have Excel and Word 2003 (SP3) with Visual Basic 6.5.

One thing I tried was the ActiveDocument.Repaginate command (I had to code it wdApp.ActiveDocument.Repaginate because I'm controlling the Word document assembly from Excel) but it did not correct the page numbers in the footer. Some of the documents that I pull in have their own footer formatting with hard-coded starting page numbers.
 
Upvote 0

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top