Export Excel To Pdf Multiple Pages

In The Search Window, Enter (1) A Name And (2) A Destination For The File, And Then (3) Click Publish.

From here, you have a few options. Click on the file menu to open it. If so, please try to delete and check the behavior.

A Snippet Of My Code Looks Like:

From the view menu select conversion options….; Hold down the ctrl key and click on the tabs of each sheet you want to save (sheet 1 and sheet 2). The code will take any number of worksheets from an excel workbook and export them to a single pdf document.

Select The Location To Save.

You can use the steps provided below to create an action to convert pdf to excel: Alternatively, you can go to export > export to xps/pdf. Drag and drop your file to the excel to pdf converter.

Open The Page Setup Dialog.

(1) holding the ctrl key, you can select multiple nonadjacent worksheets in the sheet tab bar by selecting them one by one. Select create pdf/xps document and click create pdf/xps. This is almost what wyman w said earlier, except if you're using office for mac his.

You Can Decide Whether To Optimize The File For Standard Or Minimum, Which Will Determine The Final Quality And Filesize Of The Document.

Wait as the tool saves the spreadsheet to pdf format. Sheet2.exportasfixedformat _ type:=xltypepdf, _ filename:=fname, _ quality:=xlqualitystandard, _ includedocproperties:=true. Launch you workbook that you want to convert to pdf format.