Print multiple pages to pdf

0

Save multiple sheets to . I have a reporting print multiple pages to pdf that grabs some data from a database and forms three sheets of summary report information. Feed for question ‘Save multiple sheets to . 35a7 7 0 1 1 1.

9 2 2 2h16a2 2 0 0 0 2-2v-4. 44A2 2 0 0 0 15. 68A1 1 0 0 1 5. 12a1 1 0 0 1 . M9 1a8 8 0 1 0 0 16A8 8 0 0 0 9 1zm. 69a4 4 0 0 0-. 29 0 0 1 1.

34 0 0 0 . 8 0 0 0 2. 07A8 8 0 0 0 8. 8 0 0 1 0-3. 83a8 8 0 0 0 0 7. 3A8 8 0 0 0 1.

77 0 0 1 4. At first I thought I could have a VBA macro on the sheet do this by a series of “print as PDF”, but that requires an intermediary interactive dialog box to specify the output file name. Then I find that I can just save as pdf, and the macro can set the output file name. However this creates three separate files, and I have to then later put them together externally to merge them. It is odd that save as pdf only saves one sheet, where other save modes seem to save the entire workbook.

Share.