Page 1 of 1

Page Setup

Posted: Wed Jun 08, 2016 2:28 pm
by leeparvin
Hi there

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

Thanks

Lee

Re: Page Setup

Posted: Thu Jun 30, 2016 5:51 pm
by 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];