The Word to Excel Conversion Macro is designed to clean and convert a Word based survey into Excel.
1: Installing the Word to Excel Conversion Macro
Step 1: Download the Macro files at the following link and save to your desktop (or preferred download folder):
Step 2: Extract the files from the compressed folder.
Step 3: Open Microsoft Word
Step 4: From the Macros toolbar, choose "View Macros".
- In Word 2003, you will find Macros in the "Tools" menu
- In Word 2013, 2010, and 2007, you will find Macros in the "View" menu
- In Word for Mac 2011, you will find Macros in the "Tools" menu
Step 5: Enter temp in the "Variable name" window and select "Create".
Below is an image from 2007:
Step 6: You will now be in Microsoft Visual Basic (macro editor). As shown in the image below, open the "File" menu and choose "Import File...". You will do this twice for the following two files:
Step 7: Once both are imported, exit Visual Basic and return to Word.
2: Running the Word to Excel Conversion Macro
Step 1: Open the survey in Word.
Step 2: From the Macro toolbar, choose "View Macros".
Step 3: Select the "startDecipher" macro and select "Run".
Step 4: The default settings will be loaded in the Word to Excel Conversion Macro. Simply select "Prepare XLS" to proceed.