Printing an Excel Worksheet from VB
Posted on 2003-02-20
This is the problem I am facing.
I have created a worksheet, containing about 10 coluums ans rows. The data for the worksheet is input from a DB Recordset.
Now, I need to print the Active Worksheet to a Printer, in Landscape mode.
I do not have the option to make it the default printer.
I am printing the worksheet using :
Is there any way to print this sheet in Landscape ( by setting some properties in the Worksheet), without making the printer the default and setting the orientation of the printer object ?
I would appretiate any help in this matter.
But i cannot change the orientation.