AnsweredAssumed Answered

Macro sub that allows users to select a printer

Question asked by Matt Sobotka on Jul 17, 2016
Latest reply on Jul 20, 2016 by Elmar Klammer

I currently have a macro that allows a user to paste a directory/filepath into a user form, then populates a listbox with drawings only, then allows the user to select some or all drawings within that filepath, and prints. (only it prints to the last place each individual drawing was printed to instead of allowing the user to select the desired printer)


For example if user A prints a document to printer A, when user B prints the same document using the macro it automatically prints to printer A. I do not know how to let the user pick a printer within the macro.


I want to add a function that allows the user to select a printer while selecting which drawings he/she wishes to print.