MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro Printer Select


Posted by RoB on August 29, 2001 4:04 PM

Is there a way to define which network printer i want an excel file to use in a macro? i assume i would do this on the open event. I have a sheet that needs to be printed on an Impact printer on our network. If a user opens the file, THEN changes the printer, the margins get messed up. So i need the printer to be changed before the file opens so that the margins wont get messed up.

can someone give me an example of some code that will do this?
Thanks


Posted by RoB on August 29, 2001 5:58 PM

OK, nevermind this question, have another above this post