I have a macro for excel that I use on a xl file that I download from a
server. How do I email that macro to a friend?
thx

Hi Leo

Paste the macro in the body of the mail or paste in a txt file and send it.
Or send a workbook with the macro.

--
Regards Ron de Bruin
http://www.rondebruin.nl



"leo" wrote in message ...
I have a macro for excel that I use on a xl file that I download from a
server. How do I email that macro to a friend?
thx

or
go into the VBA editor export the module to your desktop and mail it
that way.


Then the recipient can import that macro into their spreadsheet.


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=569050

I opened the macro and pasted it into an email. How does the receiver store
it as a macro on his computer?

"Ron de Bruin" wrote:

Hi Leo

Paste the macro in the body of the mail or paste in a txt file and send it.
Or send a workbook with the macro.

--
Regards Ron de Bruin
http://www.rondebruin.nl



"leo" wrote in message ...
I have a macro for excel that I use on a xl file that I download from a
server. How do I email that macro to a friend?
thx

The recipient will open a workbook and create a general module.

Recipient will then copy the macro text from the email and paste it into the
module.

Just the reverse of what you did to copy/paste into the body of the email.


Gord Dibben MS Excel MVP

On Mon, 7 Aug 2006 16:41:01 -0700, leo wrote:

I opened the macro and pasted it into an email. How does the receiver store
it as a macro on his computer?

"Ron de Bruin" wrote:

Hi Leo

Paste the macro in the body of the mail or paste in a txt file and send it.
Or send a workbook with the macro.

--
Regards Ron de Bruin
http://www.rondebruin.nl



"leo" wrote in message ...
I have a macro for excel that I use on a xl file that I download from a
server. How do I email that macro to a friend?
thx

And just to add to Gord's response, that's a pretty good reason to avoid sending
the text version of the code.

Why not just send the workbook--or even create a dedicated workbook with your
utilities in it and share that workbook?

Gord Dibben wrote:

The recipient will open a workbook and create a general module.

Recipient will then copy the macro text from the email and paste it into the
module.

Just the reverse of what you did to copy/paste into the body of the email.

Gord Dibben MS Excel MVP

On Mon, 7 Aug 2006 16:41:01 -0700, leo wrote:

I opened the macro and pasted it into an email. How does the receiver store
it as a macro on his computer?

"Ron de Bruin" wrote:

Hi Leo

Paste the macro in the body of the mail or paste in a txt file and send it.
Or send a workbook with the macro.

--
Regards Ron de Bruin
http://www.rondebruin.nl



"leo" wrote in message ...
I have a macro for excel that I use on a xl file that I download from a
server. How do I email that macro to a friend?
thx




--

Dave Peterson

or why don't you do it the way I said originally and avoid all the above
problems


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=569050