MacroCopy
 

How to copy macro from another file?
When i copy already, it seems that another file has to opened up.

MacroCopy
 

To do it manually, you'll have to open both workbooks.

Then you can go to the VBE and select text in the procedure you want copied and
edit|copy.

Go to the other workbook's project and open a module and edit|paste. (or make a
new module and paste there.)

If you want to copy the entire module from one project to another project, you
can use

Ctrl-r (to see the project explorer)
select the module in the project that you want to copy
and drag it to the other workbook's project.

======
If you have the code in a text file (not within a workbook), you can use code to
import it into your project.

See Chip Pearson's site:
http://cpearson.com/excel/vbe.htm

kyoshirou wrote:

How to copy macro from another file?
When i copy already, it seems that another file has to opened up.

--

Dave Peterson