Excel vba to print to a specific printer

[BORUCH]

hi

i would like an excel vba that can print out two copies of the excel sheet to a specific printer

thanks

 

[davesexcel]

Check out this thread.

Printing: VBA code to select printer

Dear Excel Guru's, I've got a delimma here. I've got a customized print macro that uses a userform to display all pages in a workbook that 1: have information on them and 2: are not hidden. The user simply checks off the sheets they want to print via checkboxes in the list, and then clicks...

www.mrexcel.com