Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Thu, 24 Jul 2008 00:51:14 -0700, Thomas Dettenberg wrote:
You can check the NE-ID (value 1 - 99) using the following code: your printer is for example: "HP-LJ-6" sub ne_search () dim ne as sting, printer$, i% printer = "HP-LJ-6" on error resume next for i = 1 to 99 ne = vba.format(i,"00") err.number = 0 application.activeprinter = printer & ne & ":" if err.number = 0 then exit for end if next end sub Here are a couple more options (though not necessarily better than yours) http://www.dailydoseofexcel.com/arch...-printer-port/ -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |