Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
I added the .Orientation property and that fixed the landscape.
The .FitToPagesTall/Wide appear to setup the parameters for the scaling but when you print preview the FitToPage parameters are set but the Scale Adjust option is ticked so these parameters are ignored.
I decided to set the .Zoom property to False but I keep receiving the error "Unable to set the Zoom Property of the PageSetup Class".
What am I doing wrong?
Below is the code I am using to setup the print:
ObjPage = ActiveSheet.PageSetup() ObjPage.Orientation = xlLandscape ObjPage.FitToPagesTall = 10 ObjPage.FitToPagesWide = 1 ObjPage.Zoom = @False
ObjPage.Zoom = ObjectType("BOOL", @FALSE)
Article ID: W17153
File Created: 2007:07:03:14:28:30
Last Updated: 2007:07:03:14:28:30