Excel VBA: Set PDF as printer, set filename, and set to append
We have an excel spreadsheet that runs some automated sorting and printing. Currently it loops through and selects various ranges on a sheet, and send them to a printer. The "printouts" of these ranges are never saved per-se, only printed. So we cannot easily recreate then later....
What we would like to do is have the Excel VBA:
1. select the PDF driver as the default printer (we have a few different PDF creators...)
2. set the path and filename of the SINGLE file to be created
3. Loop through the process mentioned above and write to the desired PDF - with each print command APPENDING to the existing PDF file.
4. Reset the default printer to what it was before.
or any other way to basically do the same thing.
Thanks everyone, and wishing you all well during these stay-at-home times.