Copy a macro

[pauluk]

Hi,

I need to create a macro which will copy another macro to anothe
workbook. How can you go about this

 

[Mike Fogleman]

This link may give you a starting point:
http://www.j-walk.com/ss/excel/tips/tip61.htm

Mike F

 

[Tom Ogilvy]

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.

 

[Bob Phillips]

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)