Click on the ‹VBA menu item. Then enter the following code, and then click on Save. 'Use one or more worksheets to convert Excel files and save as a PDF. For each sheet, go to file and click save as. A) To convert multiple Excel files to PDF Dim RNG As Range, s As String, rng2 As Range 'Get RNG of Excel files. Call on the RNG with 0 if there's only 1 Excel file and 1 if there's more. This example 'uses only one Excel file. Rng = RNG & 0xFF 'Get RNG of worksheet with code from 1 to 1000 and make it into a series of rows and columns to save. S = s & RNG & 0xFF 'Get S value or column from the RNG of worksheet. If it is 0, it will be replaced by the S value or column that's contained in the S values saved 'in each Excel file. For each Excel worksheet in list of 1 sheet, use Range. AppendRng(RNG) Next Note that I didn't say to use all worksheets. For this I used the function Excel. CopyRngToWorkbook. How to save multiple spreadsheets to PDF For the other method, I used the VBA code, which, in essence, uses an Excel spreadsheet as a row and column delimiter. Then, as each sheet was opened, the code would copy the cells from the range beginning at the first sheet and the end of the second sheet and past the range into which the spreadsheet was opened. To copy the sheet to the clipboard, I first found its sheet number, which I called s_1, in the S variable. Then, I used the code CopyRngToClipboard. Once the Excel spreadsheet was copied to clipboard, another cell is pasted into each cell of the range of the second Excel worksheet, then the range is closed with a VBA statement. The following screenshot shows the result after the first two sheets have been open.