how do I email amacro?

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

You haven't avoided the problem. You've just passed the problem to the
recipient. Most users of excel wouldn't know what to do with the text of a
macro (in my experience).

mr_ben wrote:

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

--

Dave Peterson

Dave Peterson Wrote: [color=blue]
You haven't avoided the problem. You've just passed the problem to the
recipient. Most users of excel wouldn't know what to do with the text
of a
macro (in my experience).

mr_ben wrote:

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

--


not how I see it

all you need to do is import the file (module), you don't need to
"touch" the text of the macro itself. (unless I'm completely missing
the point)

I may admittedly not explained the process that well... ops:


--
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 think you're going to have to tell the recipient to save the text of the
message (or the attachment) somewhere.

Then you have to explain to open excel, open the VBE, find the correct project
and import that file. Then tell the user how to run the macro.

It sounds much more difficult than just emailing a .xls file.


mr_ben wrote:[color=blue]

Dave Peterson Wrote:
You haven't avoided the problem. You've just passed the problem to the
recipient. Most users of excel wouldn't know what to do with the text
of a
macro (in my experience).

mr_ben wrote:

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

--

not how I see it

all you need to do is import the file (module), you don't need to
"touch" the text of the macro itself. (unless I'm completely missing
the point)

I may admittedly not explained the process that well... ops:

--
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

--

Dave Peterson