Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Macro to a new workbook
How do I copy a existing macro to a new workbook using macro?
-- Saalim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy one macro to another workbook | Excel Worksheet Functions | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
Copy workbook, don't copy macro | Excel Discussion (Misc queries) | |||
How can I copy a macro into another workbook? | New Users to Excel | |||
Copy macro to another workbook | Excel Discussion (Misc queries) |