Scaling?

[rbb]

I am using interop to create an Excel spreadsheet. How can I set my page setup to select the "Fit To..." option? I am using the following code to set the page count width & height, but the radio button is not selected.

 

'FYI - oSheet is an Excel.WorkSheet
oSheet.PageSetup.FitToPagesTall = 100
oSheet.PageSetup.FitToPagesWide = 1
oSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape

Thanks,

 

Rob

[Mike_R]

Add 'oSheet.PageSetup.Zoom = False' and you should be good to go.

 

:),

Mike