printers changing in macros

[KM]

An excel macro in Excel 2000 sometimes will change the
printer from Ne08 to Ne07 and won't print unless I change
the macros. Is there away to prevent this? Does it make
sense?

KM

 

[Dave Peterson]

Maybe you could loop through the connected printers and pick the one you want:

http://groups.google.com/[email protected]