Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page Break in Xls through VFP
Message
 
To
01/04/1999 07:41:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00204172
Message ID:
00204876
Views:
21
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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform