Copy Macro to a new workbook

[Saalim]

How do I copy a existing macro to a new workbook using macro?

 

[Saalim]

Thanks a lot for the link.

I use Excel 2003. The time I run this code, I get "Compile error;
User-defined type not defined".

I think I have declared all the variables correctly.

The code stops at the first line:

Function CopyModule(ModuleName As String, _
FromVBProject As VBIDE.VBProject, _
ToVBProject As VBIDE.VBProject, _
OverwriteExisting As Boolean) As Boolean

Please help.

 

[Saalim]

Thanks a ton!!

 

[Chip Pearson]

I use Excel 2003. The time I run this code, I get "Compile error;

User-defined type not defined".

In VBA, you need to go to the Tools menu, choose References, and then
scroll down to "Microsoft Visual Basic For Applications Extensibility
Lbrary 5.3" and check that item. It is in that library that the types
for VBProject, VBComponent and similary objects are defined.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)