Copy Macro to a new workbook
 

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

Copy Macro to a new workbook
 

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

Copy Macro to a new workbook
 

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

Copy Macro to a new workbook
 

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
TOLLSREFERENCES and set the reference he gives you there.


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

Copy Macro to a new workbook
 

Thanks a ton!! :-)
--
Saalim


"The Code Cage Team" wrote:


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
TOLLSREFERENCES and set the reference he gives you there.


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

Copy Macro to a new workbook
 

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.