For Excel 2022 users, here are the steps: 1. Open File Explorer window, and then click and hold Shift button. This will open the File menu, 2. From the File menu, select Open, then click on any folder or file, then click Open. 3. In the Open ‐ Open dialog box, specify Path and File name as shown in the screenshot:. 4. This will open the VBA dialog box for Excel. 5. You must specify the filename as it appears in the .ALL file, using the same format, such as the following: In the .ALL file, there are several lines that begin with this: 2. In this way, the VBA code will be used to change workbook names in the file, and then save the new versions of the files as PDF files. Here are the steps that you have to follow: a. Open the file that you want to convert. You have to enter the correct file name, that you want it to become a PDF file. You can use both Excel 2022 and Excel 2010. b. Open Excel in Windows Office 2007 c. Open File Explorer window in Windows Office 2007 d. In the Open ‐ Open dialog box, put a File as you usually use it, like your Excel Worksheet. Then click on Save as in the Save as dialog box. e. Choose Save as Adobe PDF file (Pro or Home). f. Set the save location on the drop-down: Click on options from the View list. g. Click Edit, and choose Save as excel 2022 format.. h. Click open. i. Open Excel in Windows Office 2010 Note: If you want to save it with more than 10 × 10 pages, then download this spreadsheet and edit it. 5. To convert more than one workbook or work sheet to PDF file, please follow this formula. In your VBA code, use the following lines: 1. In the VBA code, Sub Open_Convert_File_And_Save As ‹New› 2.