Default Printer

[kclong]

I have a macro that several employees that says when they run a certain file, it will be printed to a certain network printer. However, now I have changed the where they will print for any other file they want printed (unless they change it themselves, or they close excel, reopen it in which case it will point to their default printer). Here's my questions, after printing to the network printer for the macro they run, how do I write the macro to say now change the printer back to their default printer (which is different for each employee)?

 

[mrmmickle1]

Look at this Microsoft Thread: How do I change default printers in VBA - Microsoft Community