Send a macro

G

Gord Dibben

Several methods.........don't know what is the best way, all involve some work.

1. Copy the macro code and open Notepad. Paste into Notepad and save then send
for "someone else" to copy to a module.

2. Export the module as *.bas file and send that for importing into a workbook.

3. Send the workbook with the macro.

Someone else can copy the macro or module to wherever they wish.


Gord Dibben MS Excel MVP
 
W

Wanna Learn

Hello Gord Thanks..
Sounds like 3 is the easiest way. If I send the workbook I suppose the
macro has to be saved in a personal workbook so that they can use with any
workbook . Is that correct?
 
G

Gord Dibben

Yes, they could copy it to their Personal.xls which makes it available for all
open workbooks.


Gord
 
F

Flintstone

I would like to send a workbook to another user, but I do not want them to
have to go through the additional steps of pasting the Macro into their
Personal folder.

If the Macro will only be used in one workbook, is there a way to attach the
Macro to the workbook before sending to another user? I am sure that I am
missing something very simple. . . ?
 
G

Gord Dibben

Did you miss step 3?

If the macro is to be used only on the workbook you send to other user,
simply store the macro in a module in that workbook and save the workbook.

Send to other user.


Gord
 
F

Flintstone

Thanks Gord. . . Step number 3 is exactly what I am trying to do. I want to
store the macro in the workbook, but I do not know how? I will continue my
search. . .
 
G

Gord Dibben

Good to hear you're fixed up.

I did not realize you would not know about copy/pasting a macro from one
book to another or I would have provided some instructions.

Gord
 
Top