Changing Excel Object's page setup wthout having a printer installed

[alijaffer]

I want to be able to set the page settings of an excel report that i
being generated on our server. The problem is that the server does no
have a printer installed on it.

Is there any way for me to do this?

If I install a printer the following code works. If I don't then i
goes to the errorhandler.

appXl.ActiveSheet.PageSetup.Orientation = xlLandscape

Thanks,

Ali Jaffe

 

[Tom Ogilvy]

You need to have a print driver installed (you don't need to have an actual
printer installed).

 

[alijaffer]

I'm just trying to find out if it is possible to do it withou
installing a printer driver.

Thank

 

[Jake Marx]

Hi Ali,

I'm just trying to find out if it is possible to do it without
installing a printer driver.

As Tom said, it is not possible to use PageSetup without installing a
printer driver.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]