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)



On Mon, 17 Nov 2008 05:16:00 -0800, Saalim
wrote:

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.