Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_components thread: Unable to set Excel PageSetup.Orientation


Message #1 by jeff.montgomery@m... on Fri, 13 Sep 2002 14:10:47
I am creating an Excel spreadsheet with VBScript (ASP), and I get the 
following error when I try to set the page orientation for the worksheet:

Run-time error '1004':
Unable to set the Orientation property of the PageSetup class 

I have added a printer on the web server as per MS's Knowledge Base 
article Q172320 (at least one printer must be installed for the code to 
work), and I have used the new printer to print from Excel to make sure it 
works. I am able to create the workbook/worksheet, fill it, or save it, 
but it still errors when I try to set the page orientation. I got this 
same setup to work on a Win2000 web server in development. Any ideas?

Thanks,

Jeff Montgomery
jeff.montgomery@m...

  Return to Index