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

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/

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/

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/