Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a Page Break In Excel
Message
From
08/01/2001 15:39:12
 
 
To
05/01/2001 08:30:42
Todd Wolfe
Certified Marketing Services
Kinderhook, New York, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00459740
Message ID:
00460784
Views:
19
Hi Todd,
I always do something that looks similar to the following:

xlSheet.HPageBreaks.Add(xlSheet.Rows(lnRowNumb + 1))


where 'xlSheet' is an object refering to a specific excel sheet, not the whole application. What that's saying is to add a horizontal page break before the row listed between the '()'. You can do 'VPageBreaks' too, but then you must specify a column in the '()' instead of a row.
Paul A. Busbey
Victoria Insurance
Previous
Reply
Map
View

Click here to load this message in the networking platform