Type in the following VBA code using the keyboard in the code editor, then click OK to close the code editor. Paste from Excel — Super User How to batch convert Word documents from other file formats to PDF — 1. Type this into the main Excel file, and then click OK to open the file. How to Batch Convert Word to PDF Files with VBA Select [Ctrl + Shift + V] and a macro will be created in the Word document. Open the macro. 2. Now, you can click the batch convert Word files button, and select the destination folder from the dropdown. (The destination folder is the folder that was created when your batch converted the Word file.) 4. Open Acrobat and you will see the Word files that you chose were converted by this macro. The Word file is now converted to PDF. Note: To batch convert Word to PDF files, you will need a Mac and Adobe Acrobat. However, we have tested batch converting Word to PDF files on a PC with and without a Mac. Step 1: Save all the Word documents that you wish to convert in one folder. Step 2: Open Adobe Acrobat and select 'Create PDF' to begin the batch convert Word 4. Make sure the Batch Import tool in Acrobat is selected under the File menu. 3. Go to File > Open, select the source or output folder, click next and type in a name, for instance, Word.docx and click the button Batch Convert. How to Batch Convert Word Documents from other file formats to PDF 1. In Excel, select the cells where you want the conversion to be done and click Convert. In the Convert dialog, click File > Print from... and choose the destination, be it pd for Word document. 2. In Excel, select the cells where you want the conversion to be done and click Convert. In the Convert dialog, click File > Print from... and choose the destination, be it pd for Word document. Step 1: Save all the Word documents that you wish to convert in one folder. Step 2: Open Adobe Acrobat and select 'Create PDF' to begin the batch convert Word 2) Select the target document, and then click on File > Load.