How To Import Or Copy Vba Code To Another Workbook

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

In this video I explain how to copy or import VBA code to another workbook. This is great if you found code on the web, want to transfer code from one workbook to another, or import code modules to/from your Personal Macro Workbook.

Read the article and download the example file: https://www.excelcampus.com/vba/copy-...

Here are the 4 ways to copy VBA code or code modules between workbooks:

1. Copy and Paste VBA Code
2. Drag and Drop a Module
3. Copy Sheet Modules that contain code
4. Export/Import modules (.bas files)

I also explain how to delete or remove modules from your workbooks (VBA Projects).

Related Videos:

How to Create Your Personal Macro Workbook & Add Buttons to the Ribbon (playlist):    • The Personal Macro Workbook in Excel - The...  

VBA Code Modules & How to Run Event Macros Based on User Actions:    • How To Create Vba Code Modules In Excel  

How to Enable the Developer Tab:    • How to Enable the Developer Tab in Excel f...  

Free webinar on The 7 Steps to Getting Started with Macros & VBA: https://www.excelcampus.com/macros-we...
00:00 Introduction
01:58 Drag Drop Method
04:24 Copy to Sheet Object
05:25 Export and Import