Worksheets) to the new folder, and the associated sub-worksheets files as sub-worksheets. It is important to Make Separate Files for the Workbooks and Sub-Worksheets, to help save on disk space. · Now, create the following VBA scripts: Save All the Windows Documents as a Single PDF Create the first VBA Script to Save All the Documents as a Single PDF Now create your second VBA script to Save all the Windows Documents as a Single PDF. I have created a second workbook in which all the files are saved as individual PDF files. VBA Script to Save All the Windows Documents as a Single PDF Step 3: Use the Get-Workbook | Export-As command to create the new workbook. Get-Workbook | Export-As Step 4: Open the original Excel workbook. Step 5: Save the workbook and all the worksheets to a new folder. Step 6: Open the new workbook. Step 7: Choose any of the cells in the workbook (cell A1, 2, 3, 4 etc) then right click and select the option File | Export to PDF. (see screenshot below) Step 8: Click on the “Browse……” button Step 9: Click on the “New” button Then Click on the “Save” button on the ribbon Now, open the new workbook. It should open as a new workbook. Open the VBA dialog box using the right mouse button. Step 10: Set the Options to “General”, “File”, “Save as PDF”, “Save as” Step 11: Click OK, then OK again and close the dialog box. Step 12: Close the spreadsheet. The new workbook should open in a new window. It should have an icon. To open the workbook in Google Sheets: Click on the Open in Google Sheets button from the ribbon. Here is the template sheet used for this project. The template sheet: Separated Excel Sheet. Excel Sheets are the cells that are laid out on Excel VBA. They are created in one cell with all their data. The first column is used to store the data.