Automating Section Breaks

[RZ31188]

I have a word document that is 688 pages long and I would like to enter a section break every 8 pages. I am familiar with VBA in excel but have not used it with word before. Could anyone point me in the right direction as far as how to code this?

Thx

[fumei]

Is the number of 8 fixed?

Is it just one Section currently?

Are the current page breaks all generated by Word, or are there some manually inserted page breaks?

[RZ31188]

The word document is created by 688 tables being copied in (one on each page) from excel. Every 8th page is a different grouping that I will have to be able to have a new header on.

I believe that they are all in one section when the excel macro sends each table over.

[RZ31188]

I figured it out! I was able to put the section breaks where I needed them in my macro i wrote in excel and then in transferred over to word. Thanks though!

[Paul_Hossler]

How did you put them in on the Excel side?

Paul

[fumei]

Yes please. If you have come up with a solution it would be good to post what you did in case other may have similar issues.

[RZ31188]

Wherever I wanted a section break inserted in my word document i put this line of code to start a new section on the next page

WDApp.Selection.InsertBreak wdSectionBreakNextPage