At work we run WinXP and Office 2003. I'm having a very annoying, intermittant issue with the virtual printer ports changing on some machines. We run a lot of complicated Excel marcos, when the virtual printer port changes, the macro's will not run when a print job hits. Here's an example:
The macro depends on the NE port and printer name which is held in the registry under HKCU, example:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Devices]
"Microsoft Office Document Image Writer"="winspool,Ne00:"
"Adobe PDF"="winspool,Ne01:"
"\\\\CIMUSSRV03\\iploffice - HP LaserJet 5"="winspool,Ne02:"
"\\\\cimussrv03\\Sdfoffice - HP LaserJet 4240"="winspool,Ne03:"
"\\\\CIMUSSRV03\\XRX8560 - Lab Color Printer"="winspool,Ne04:"
"Solid Converter PDF v4"="winspool,Ne05:"
Just yesterday I had a macro stop due to the order of the printers changing on a users PC. I wiped all the printers, put them back in a specific order to maintain the Ne port numbers (they simply increment up), exported the reg key for reference and corrected the macro port ID's so Excel ran fine.
Later in the day, the user logged off the domain at lunch and logged back in afterward. Lo and behold, the printer that WAS on Ne03 moved to Ne00 and bumped all the other printers up an Ne port. Of course, the user made NO CHANGES to the printers manually....they don't even know how to. For some reason, WinXP decided to do this on it's own. I checked with our MIS domain admin and he swears there's nothing that would affect printers during logon.
ANY IDEAS WHY WINDOWS DOES THIS? Any ideas on how to STOP it from doing this?
The macro depends on the NE port and printer name which is held in the registry under HKCU, example:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Devices]
"Microsoft Office Document Image Writer"="winspool,Ne00:"
"Adobe PDF"="winspool,Ne01:"
"\\\\CIMUSSRV03\\iploffice - HP LaserJet 5"="winspool,Ne02:"
"\\\\cimussrv03\\Sdfoffice - HP LaserJet 4240"="winspool,Ne03:"
"\\\\CIMUSSRV03\\XRX8560 - Lab Color Printer"="winspool,Ne04:"
"Solid Converter PDF v4"="winspool,Ne05:"
Just yesterday I had a macro stop due to the order of the printers changing on a users PC. I wiped all the printers, put them back in a specific order to maintain the Ne port numbers (they simply increment up), exported the reg key for reference and corrected the macro port ID's so Excel ran fine.
Later in the day, the user logged off the domain at lunch and logged back in afterward. Lo and behold, the printer that WAS on Ne03 moved to Ne00 and bumped all the other printers up an Ne port. Of course, the user made NO CHANGES to the printers manually....they don't even know how to. For some reason, WinXP decided to do this on it's own. I checked with our MIS domain admin and he swears there's nothing that would affect printers during logon.
ANY IDEAS WHY WINDOWS DOES THIS? Any ideas on how to STOP it from doing this?