Can you send a Macro to someone else by email?

D

Dave Peterson

You could export/copy the code into a simple text file (or even just paste into
the body of your email.

But then you have to tell the user how to use this to create a workable macro.

Can you just send the workbook that contains the macro and then have that user
open that workbook and run the macro in that workbook?
 
S

samprince

Export the Macro in VB Editor, will be saved as a .bas i dont know
whether some emails will block/allow it to be uploaded though
 
D

Dave Peterson

You can rename the .bas to .txt or just copy|paste directly into the body of
your email.

I wouldn't do it that way, though.

I'd just send the workbook with the macro.
 
Top