Radical789
Member
Our office uses a lot of macro's in Excel. We had been using MS Office version 2007. Recently we began upgrading to Office 2010 when we would install a fresh OS (Win 7 Pro in this case)
We were fine with Windows 7 Pro and Office 2007 so it seems to be an Office 2010 issue.
Typically to find out the system name of the printer that needs to be in the macro we would "Record a new Macro", choose "Print", select each printer on our list of printers, and then "Stop Recording". At that point we would choose to Edit that macro just so we could see what the system called each printer. It would normally be some like:
Application.ActivePrinter = "\\FS1\Canon iR5050 on Ne06:"
Each of our printers ended in a different "Ne#".
Our problem now is that MS Office Version 2010 does not show that list of printer names when we record a macro. When we have a fresh OS install the printer list might vary slightly. Therefore, we cannot edit our old macros with the new printer names because we can't see what they are on that PC.
It is not feasible to record new macro's from scratch because there are too many of them and most of them are very complicated and would take days to try to recreate.
Does anyone know another way to find out these system printer names so we can edit our macros?
Carol
We were fine with Windows 7 Pro and Office 2007 so it seems to be an Office 2010 issue.
Typically to find out the system name of the printer that needs to be in the macro we would "Record a new Macro", choose "Print", select each printer on our list of printers, and then "Stop Recording". At that point we would choose to Edit that macro just so we could see what the system called each printer. It would normally be some like:
Application.ActivePrinter = "\\FS1\Canon iR5050 on Ne06:"
Each of our printers ended in a different "Ne#".
Our problem now is that MS Office Version 2010 does not show that list of printer names when we record a macro. When we have a fresh OS install the printer list might vary slightly. Therefore, we cannot edit our old macros with the new printer names because we can't see what they are on that PC.
It is not feasible to record new macro's from scratch because there are too many of them and most of them are very complicated and would take days to try to recreate.
Does anyone know another way to find out these system printer names so we can edit our macros?
Carol
