Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a macro
Hi,
I need to create a macro which will copy another macro to anothe workbook. How can you go about this -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a macro
This link may give you a starting point:
http://www.j-walk.com/ss/excel/tips/tip61.htm Mike F "pauluk " wrote in message ... Hi, I need to create a macro which will copy another macro to another workbook. How can you go about this? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a macro
See Chip Pearson's page on using code to work with code
http://www.cpearson.com/excel/vbe.htm It doesn't have sample code for exactly what you are asking, I don't believe, but it has all the basic information you need. -- Regards, Tom Ogilvy "pauluk " wrote in message ... Hi, I need to create a macro which will copy another macro to another workbook. How can you go about this? --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a macro
Simplest way is to copy the code to a text file and copy it in the other
workbook with ActiveWorkbook.VBProject.VBComponents("Module1") _ .CodeModule.AddFromFile "C:\myTEst\volker1.xls" HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "pauluk " wrote in message ... Hi, I need to create a macro which will copy another macro to another workbook. How can you go about this? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy workbook, don't copy macro | Excel Discussion (Misc queries) | |||
Macro to copy | New Users to Excel | |||
COPY MACRO | Excel Programming | |||
Macro To Copy Down | Excel Programming |