Thread: Copy a macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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/