Page Setup

[leeparvin]

Hi there

How do I set Page Setup -> Page ->Scaling -> Fit To, using Excel 97

Thanks

Lee

[KenWhite]

Same as you would using Excel 2007, using the XLS Workbook's WorkspaceOptions, where XLS is a TXLSReadWriteII5:

Code: Select all

  XLS[0].WorkspaceOptions := [woFitToPage];