Hello folks,
I created two buttons in my excel sheet. If I click on button1, it is supposed to print the sheet on pdf file. If click on button2, it is supposed to send the print job to the printer.
I am using the following command in my script:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
which sends the print job to the default printer.
Do you know if there is a way to define the printer I want to use for the print job in the script?
Umit
Bookmarks