I have built a macro using Excel 2007 that will print all files located in a specified folder. The macro prints these files in alphabetical order. I need all of these documents to be sent to the color printer which is not the default printer. I came across the following code to change the printer in excel:
However this does not achieve what I am looking for because I am not printing exclusively excel workbooks. I am also printing PDF files and Word Documents. I need the macro to change the system default printer so the non-excel files go to the same printer as well. I found the following article which achieves my goal in Visual Basic, but I need to do this with VBA.