How do you email Macros?

J

JulieD

Hi

i wouldn't because they could overwrite their personal.xls and then everyone
could get upset :)

one way:
in the VBE if you right mouse click on the module holding the macros that
you want to email you can export them .. as a *.bas file ... attach this to
your email (zip it first as i don't think outlook lets BAS files through)
and then all they have to do is is go into the VBE window and do file /
import & import the bas file

Hope this helps
Cheers
JulieD
 
G

gacollege

Normally I would save the macro within the workbook and not within the
folder on your computer. Only problem is that if the other person has
a different version of Excel, the macro may not work.

Hope this helps........

Richard
 
D

Dave Peterson

I'd just rename it to something else (BLUDUtils.xls) and mail that.

(Unless you were 100% positive that personal.xls didn't exist for anyone in your
recipient list.)
 
Top