General information
Category:
Coding, syntax & commands
>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))
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only