| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintOut Method, Set ActivePrinter with a variable
I would like to have an Excel macro print to a printer defined in a
variable so I dont have to hard code the printer name in the code. I have been successful with the following code: ThisWorkbook.PrintOut ActivePrinter:="Printer Name" What I would like to do is something like: Set PrinterNameVariable = "Printer Name" ThisWorkbook.PrintOut ActivePrinter:=PrinterNameVariable Any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA ActivePrinter | Excel Programming | |||
| Printout method: in color, duplex | Excel Programming | |||
| Problem with the PrToFileName parameter when using the Printout method on a worksheet | Excel Programming | |||
| Excel vba printout method | Excel Programming | |||
| Method 'ActivePrinter' of object '_Application' failed | Excel Programming | |||
Threaded Mode
