Macros Backup and Restore in Microsoft Word and Excel

The Office of Information Technology always recommends backing up any important information to be restored later for use.  The steps below are how to backup and restore macros in Microsoft Word and Excel.

Steps to Export Word and Excel Macros. This process saves macros for backup purposes.

1. Open the Word documents or Excel spreadsheets where you have your macros saved.
2. Press ALT+F11 to open the VBA Editor.
3. On the modules which contain macros, right click and select Export File which will result in text files with extension *.bas.

Steps to Import Word and Excel Macros. This process restores macros for use.

1. Open the Word documents or Excel spreadsheets where you have your macros saved.
2. Press ALT+F11 to open the VBA Editor.
3. Right click on the module where you want to import the macro from and select Import File.
4. Browse to and select the macro to be imported.

Additional Information

• Steps to Export Word and Excel Macros LinkedIn Learning Video
• Steps to Export and Import Macros into Word and Excel
• Enable or Disable Macros in Microsoft 365