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


"The Code Cage Team" wrote:


Here is the definitive answer:

'Programming In The VBA Editor'
(http://www.cpearson.com/excel/vbe.aspx)


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30424