J
John MacLaren
I am creating an Excel spreadsheet on the fly with OWC10 and ASP and I
need to set various page level options such as margins, footers and
zoom level. In Excel I can access these in the File..Page Setup or
via a Macro and the PageSetup object is at the Worksheet level but in
OWC10 I can find no reference in the help files for a PageSetup object
either at the worksheet or workbook level and when I try to reference
any such thing as .Zoom or .LeftMargin I receive an error.\
If there is no PageSetup object what properties or methods can be used
to set Margins and Footers. And if there is no way, why not ? Those
seem to be crucial items almost every spreadsheet would need to set,
such as page orientation, etc.
need to set various page level options such as margins, footers and
zoom level. In Excel I can access these in the File..Page Setup or
via a Macro and the PageSetup object is at the Worksheet level but in
OWC10 I can find no reference in the help files for a PageSetup object
either at the worksheet or workbook level and when I try to reference
any such thing as .Zoom or .LeftMargin I receive an error.\
If there is no PageSetup object what properties or methods can be used
to set Margins and Footers. And if there is no way, why not ? Those
seem to be crucial items almost every spreadsheet would need to set,
such as page orientation, etc.