How do you email Macros?

[bludovico]

ANy quick and easy way? Should I email the PERSONAL.XLS

 

[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

 

[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

 

[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.)