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

A

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
 
T

Tom Ogilvy

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

alijaffer

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

Thank
 
J

Jake Marx

Hi Ali,
I'm just trying to find out if it is possible to do it without
installing a printer driver.
Click to expand...

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]
 
Top