Excel VB - Pagebreak

R

robbath

(It seems that nobody could help me with my earlier post (btw help i
still required)...)

Anyway. I am trying to create a word document using Excel VB. I ca
achieve a fair amount, but Excel is not happy about me using th
statement:

Selection.InsertBreak Type:=wdPageBreak

Excel doesn't recognise wdPageBreak, and instead sees it as a undefine
variable.

So, does anybody know how to create a page break in Excel VB?

thanks,

Robert Bat
 
L

Lady Layla

what is wdPageBreak

HPageBreaks = Horizontal and VPageBreak = Vertical


: (It seems that nobody could help me with my earlier post (btw help is
: still required)...)
:
: Anyway. I am trying to create a word document using Excel VB. I can
: achieve a fair amount, but Excel is not happy about me using the
: statement:
:
: Selection.InsertBreak Type:=wdPageBreak
:
: Excel doesn't recognise wdPageBreak, and instead sees it as a undefined
: variable.
:
: So, does anybody know how to create a page break in Excel VB?
:
: thanks,
:
: Robert Bath
:
:
: ---
:
:
 
Top