How can I copy a macro into another workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
Basically you just open the module in which the macro resides and select the
text from Sub macro() to End Sub.

Copy it and paste into a module in your other workbook.

But......nothing is rarely that simple<g>

Is the macro workbook-specifice or worksheet-specific?

Does it refer to named ranges in the original workbook?

If you could post the code perhaps we could get a better idea of how to copy and
edit if needed.


Gord Dibben MS Excel MVP
 
Hello,

It is workbook specific and it refers to name ranges. In my workbook there
are 16 different macros and 4 sheets. It’s a form that I send through our
web based program, when it goes through our system it stripes the form of the
macros. I was trying to find a way to add the macros back onto the form
after it goes through our system.

Jodell
 
You could just export the module(s) with the macros as *.BAS files then
re-import those back in after the workbook has gone through the system.

Do you have any event code in the 4 sheets or in the Thisworkbook module?

You will have to export those as *.CLS files and re-import them as Class
Modules, copy the code to your 4 sheets then delete the Class modules.

Chip Pearson has a series of macros for adding modules to a workbook.

http://www.cpearson.com/excel/vbe.htm

BTW.........how does your system actually strip the macros from the file?


Gord
 
I am going to try to do as you suggested. I looked around for an event code
but…..I’m not sure what that is or where to find it.

Our developers are trying to figure out what’s going on with the macros; I’m
their little pain right now.

Thank you for your help.
 
Back
Top