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