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

--
Message posted from http://www.ExcelForum.com

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

--
Regards,
Tom Ogilvy

"alijaffer " wrote in message
...
I want to be able to set the page settings of an excel report that is
being generated on our server. The problem is that the server does not
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 it
goes to the errorhandler.

appXl.ActiveSheet.PageSetup.Orientation = xlLandscape

Thanks,

Ali Jaffer


---
Message posted from http://www.ExcelForum.com/

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

Thank

--
Message posted from http://www.ExcelForum.com

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]