ExcelBanter - Setting Printer

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Setting Printer (https://www.excelbanter.com/excel-programming/302290-setting-printer.html)

Nathan[_4_]

Setting Printer

Is there a way to set the printer to use for a worksheet
with VBA?

Binzelli[_10_]

Setting Printer

Which version of Excel are you using ?

"Nathan" wrote in message
...
Is there a way to set the printer to use for a worksheet
with VBA?

Nathan[_4_]

Excel 2002 SP2

Excel 2002 SP2

-----Original Message-----
Which version of Excel are you using ?

"Nathan" wrote in message
...
Is there a way to set the printer to use for a worksheet
with VBA?

.

Fred[_17_]

Excel 2002 SP2

Try using the application.printer object

"Nathan" wrote in message
...
Excel 2002 SP2

-----Original Message-----
Which version of Excel are you using ?

"Nathan" wrote in message
...
Is there a way to set the printer to use for a worksheet
with VBA?

.

nathan

Think I found it

Application.ActivePrinter
-----Original Message-----
Try using the application.printer object

"Nathan" wrote in message
...
Excel 2002 SP2

-----Original Message-----
Which version of Excel are you using ?

"Nathan" wrote in message
...
Is there a way to set the printer to use for a
worksheet
with VBA?

.

.

All times are GMT +1. The time now is 06:20 AM.