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... :oops:

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