Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Copy VBA Module to Different Workbook

Posted on by Annie D

Microsoft Excel – Copying VBA Module from one workbook to another.
John B has a workbook with a lot of data.
He created a new workbook with a macro for testing. Now that the macro is working, he wants to copy the working macro from the test workbook to the workbook with all of his data.
This video shows how to launch the VBA Editor with Alt+F11
Display the Project Explorer.
Drag the module from one workbook to another.

Remember to Save As the workbook as XLSB or XLSM. If you save the workbook as XLSX, your macros will be removed.

Topics:
How to copy Excel VBA?

How To Copy A Macro From One Excel To Another
How To Copy A Macro From One Excel Workbook To Another
How To Copy A Macro In Excel

How To copy macros Excel?
How Do I Copy A Macro Fromone Excelfile To Another?

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comTue, April 4, 2023 8:44pm