Excel Question

[Fleer]

I created an excel application in VFP, but I can't find out how I can insert a Horizontal Page Break in my XL-file

this is an example prog.

PUBLIC poxlApp
poxlApp=createobject("Excel.Application&quot
poxlApp.Workbooks.Add
poxlApp.Range("A2&quot.Select

and then to insert the pagebreak, in VBA it's like this
"ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell"

Any suggestion on how to put this in VFP is appreciated.

Fleer

 

[jonscott8]

oCell=poxlapp.activecell
poxlapp.ActiveWindow.SelectedSheets.HPageBreaks.Add(oCell) Jon Hawkins