Excel Copy VBA Module to Different Workbook #shorts

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 leave the workbook as XLSX, your macros will be removed.

Topics:
how to copy Excel vba?
how to copy macro Excel?
How Do I Copy A Macro Fromone Excelfile To Another?
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

Transcript of the video:

John B wants to copy VBA code from a new workbook to an old workbook.
He has this version with all of his data, but this small version has a macro that's working.
Press Alt+F11 View, Project Explorer.
Find the two workbooks.
Here's the module that he wants to copy.
Just drag the module from here, to there.
Super important.
If this workbook is saved as XLSX, you have to do File, Save As.
And change the file type into XLSB or XLSM or you'll lose the macros.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.

 

[rlv01]

I like the new '#shorts' format, as it requires the creator to distill the info and squeeze out clear information. Nice.