Delete Page Break in word using VBA in excel

[excelpunk]

Hello All!

I have a word template which is of 2 pages, it has just one page break, I have vba code in Excel, which opens this template, manipulates something and then saves the template with a different name.

However, I have now realized that in some cases I need to delete that page break. What vba code should I include to make this happen.

My apologies if the post is not relevant.

 

[ZVI]

Thanks again! This worked the way I wanted. Just amazing! Thanks.

Just a couple of queries:

Can you tell me what went wrong with the code I tried with:
with wordtemp.activedocument.tables(1).Select
'followed by recorded macro
Selection.Sort ExcludeHeader:=True, FieldNumber:="Column 1", SortFieldType _
:=wdSortFieldAlphanumeric, SortOrder:=wdSortOrderAscending, FieldNumber2 _
:="", SortFieldType2:=wdSortFieldAlphanumeric, SortOrder2:= _
wdSortOrderAscending, FieldNumber3:="", SortFieldType3:= _
wdSortFieldAlphanumeric, SortOrder3:=wdSortOrderAscending, Separator:= _
wdSortSeparateByCommas, SortColumn:=False, CaseSensitive:=False, _
LanguageID:=wdEnglishUS, SubFieldNumber:="Paragraphs", SubFieldNumber2:= _
"Paragraphs", SubFieldNumber3:="Paragraphs"

Also, do you have links to any resources where controling word from Excel is explained?
I dont understand why the recorded macro throws error when I use it from Excel! The same code works fine when I use it in word modules. Strange!

Not sure exactly where it faults without seeing of your full code, but there are a plenty of Word's constants in that code started with wd which are not known for Excel.
You need do redefine it all in the Excel code (see my example of Const ...), or replace it all by its numeric values (in Word select the constant and press F2), or use Early Binding and set reference to MS Word via Excel VBE - References.
MacroRecorder builds raw code with unwanted selections, using of Range is faster and preferable as well as for the Excel code.

To find resources try googling How to automate Microsoft Word from Excel