Nishit,
You'll need to use the standard VFP parameter format:
ActiveWindow.SelectedSheets.HPageBreaks.Add(parm1, parm2, parm3....) You'll need to know the order of parameters in the ADD() method, and the acceptable values for the "Before" parameter.
I don't know the correct parameters and their order for the ADD command, but there are lists of Excel commands available here and on related web sites.
Hope this will get you started,
Barbara
>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