Excel 2000 macro, W2K Mult. Printers
Bob
I was advised to see if someone has an answer for me here. I have two PCs
that are duplicated in all the software on them. I also want them to be
able to add network printers that an Excel macro can switch and send reports
to each. The recorded macro contains the Servername\que name on "Port".
I have found the registry key mentioned below. This person says there may
be a way to work the macro to get the printer port. That way if someone
removes and reloads the printer everything still works. There is also a
remote chance someone on a different machine may try to run this macro.
Thanks,
Bob
Windows 2000 sp2
Office 2000 Pro
Printers on LAN
HP Laser networked printer
Lexmark Laser networked printer
------------ Harlan Grove's advice------------------------------------
Your problem could be solved with more consistent system admin. If both
machines had the exact same network printer queues installed in the exact
same order, your problem would be solved. Under no circumstances does it
make sense to modify the Registry. There could be MANY hidden pieces of
configuration info in the Registry that could affect printing to network
queues.
What you may have to do is get information from the Registry, specifically,
the values under the key
HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Devices
The data for the value corresponding to the network print queue you want to
use would show the Ne## port address you'd need to include. [Sheesh, another
place in which 123 is more intelligent than Excel - 123 doesn't force the
user to specify the network port, it only need the network queue's name - it
seems to be intelligent enough to search the Registry to find the network
port itself.] As for searching the Registry, you may want to ask in
microsoft.public.excel.programming.