I am taking an excel worksheet and on closing I want it to print the file to .pdf using pdf printer.
Currently, this function works, but it only sends the pdf file to the destination folder set under the printer preferences.
Is there a way to manipulate these preferences in order to choose my file destination without having to open the print settings?
Bookmarks