Macros Backup and Restore in Microsoft Word and Excel

This document is intended to guide end users through the process of backing up and restoring macros created in Microsoft Excel. 

 

 

Information

 

The Office of Information Technology always recommends backing up any important information to be restored later for use.  The steps below are how to back up 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.

• 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

 

 

Escalation

 

Any questions on process or content contained in this document should be escalated through the NCSU Help desk and a have an incident assigned to the OIT_DESKTOP_SUPPORT team. 

 

 

Related Documentation

 

https://www.linkedin.com/learning/word-automating-your-work-with-macros/export-or-import-a-macro-module?u=53565897

https://www.techrepublic.com/article/export-your-vba-code-for-use-in-another-excel-application/

https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6