Copy Macro to a new workbook

S

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.
 
T

The Code Cage Team

Read Chips page carefully, you will see that you need to make sure you
have checked a reference in your reference library, in the VBE goto
TOLLS>REFERENCES and set the reference he gives you there.


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
 
C

Chip Pearson

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

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)
 
Top