Page Setup *The PageSetup object is not available in ExcelWriterSE, ExcelWriterLE, and ExcelWriter Free.

Page Setup in Microsoft Excel

In Microsoft Excel, you can set the layout properties of a printed worksheet by selecting Page Setup... from the File menu:

If you set Page Setup properties in Microsoft Excel, and open the spreadsheet with ExcelWriter, the Page Setup settings will be preserved. Alternatively, use ExcelWriter's PageSetup object to set layout properties in script.

Top

ExcelWriter's PageSetup Object

* The PageSetup object is not available in ExcelWriterSE, ExcelWriterLE, and ExcelWriter Free.

ExcelWriter's PageSetup object represents the layout properties of a printed worksheet. To create a PageSetup object with ExcelWriter, use,

	Set PageSetup = Worksheet.PageSetup

Note: Since this object is tightly related to client's printer setup, for those computers without a printer setup, changes to this object have no effect.

Top

Example

Top

Copyright © 2003, SoftArtisans, Inc.