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
Bookmarks