![]() |
|
#1
|
||||
|
||||
![]()
I seems to me that maintaining a 'main' document with INCLUDETEXT fields pointing to each of the 'secondary' documents would be no more onerous than using a macro employing an array of document names that is just as susceptible as INCLUDETEXT fields to your chapters being renamed.
As for your macro, the path is missing the final separator. The code could also be improved in other ways: Code:
Sub PageNumberReset() Application.ScreenUpdating = False Dim pgNo As Long, n As Long Dim StrPath As String Dim ArrNames, wdDoc As Document ' Specify the path to the document files StrPath = "C:\MyDocs\Example\" ' Create an array holding the document file names, in sequence ArrNames = Array("Chap1.docx", "Chap2.docx", "Chap3.docx") For n = 0 To UBound(ArrNames) Set wdDoc = Documents.Open(FileName:=StrPath & ArrNames(n), AddToRecentFiles:=False) With wdDoc With .Sections.First For Each HdFt In .Headers With HdFt If .Exists = True Then .PageNumbers.RestartNumberingAtSection = True .PageNumbers.StartingNumber = pgNo + 1 End If End With Next For Each HdFt In .Footers With HdFt If .Exists = True Then .PageNumbers.RestartNumberingAtSection = True .PageNumbers.StartingNumber = pgNo + 1 End If End With Next End With pgNo = pgNo + .ComputeStatistics(wdStatisticPages) .Close Savechanges:=wdSaveChanges End With Next n Set wdDoc = Nothing Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] Last edited by Charles Kenyon; 05-13-2021 at 08:53 AM. |
#2
|
|||
|
|||
![]()
I completely agree that entering each file name into the array is just as onerous. I was hoping to try the macro first to see if it works before trying to edit with some sort of file dialog instead of an array.
Thanks very much for the code! I tried it, and it seemed to have done something to the files because the "date modified" has updated. However, when I check the page numbers of the files, the first page of each document is still 1. I'm just using a { PAGE } code in the footers. Am I doing something wrong? |
![]() |
Tags |
macro, pagenumber, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Page Numbering Macro | mbr50 | Word VBA | 4 | 01-20-2020 04:47 PM |
![]() |
Spyke44 | Word | 4 | 10-18-2015 08:18 AM |
![]() |
prakhil | Word VBA | 1 | 06-27-2014 06:20 AM |
Multiple page document to individual multiple page documents | Legger | Mail Merge | 3 | 06-15-2014 06:36 AM |
![]() |
reitdesign | Word | 3 | 12-12-2008 11:55 AM |