>Hello,
>
> I have created object as excel object and insert data in it. I ma facing problem when i am trying to add page break in that, Syntax is
>
>ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
> ----------
>But if i give this command, Foxpro says Syntax error because there is space between .Add and Before If i try to do it through brackets, Xls gives error. is there any other way to add page break?
>
>TIA
>Amit

Here is some code I have used.

oX = CreateObject('Excel.application')

oX.visible = .t.
ox.workbooks.add
oa = oX.workbooks.Item(1)
oas = oa.sheets.item(1)
oas.ResetAllPageBreaks
oas.pagesetup.ZOOM = 80
oas.HPageBreaks.Add(oas.cells(20, 1))