Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Active Printer Port Problem
I'm trying to use vba to print a worksheet. Here's the bit of code that is
causing me fits: ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Local Printer on NE03:", Collate:=True And, the problem is...The "NE03:" keeps changing when I reboot. Sometimes the printer is on NE03:. The next time it's on NE04:". So, I borrowed some code from a site ("TechTrax") that reports a bunch of info about the printers. Then, I tried to build the ActivePrinter name by combining the string "Local Printer on " with a string of the port name. However, the port name gets reported as "USB001" instead of "NE03." In my list of printers, the printer's name is simply "Local Printer". Any ideas how to do this? TIA for any help and suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printer Using USB Port Slows Page Setup | Excel Discussion (Misc queries) | |||
printer port assignment in macro | Excel Programming | |||
Capturing Data from a Com Port or Printer Port | Excel Programming | |||
active printer | Excel Programming | |||
Active printer | Excel Programming |