How can you email a macro from personal.xls

Hi all,

I have written a macro that I would like to email to all of my coworkers. I
was wondering if there is a simple way to email it to them - a way that would
not be too difficult for them to figure out how to get the macro into their
own personal.xls folders. (don't know if it matters, but I use Microsoft
Outlook)

Thanks in advance!!!!!!

You can copy the code from the VBE and paste into notepad and save with the
extension bas, attach the *.bas file then they can import it using the same
VBE into their personal.xls. Or you could just copy and paste the code into
outlook and they can high light and copy it, open the VBE insert a new module
into personal.xls and paste it into there. Of course for all of this to
happen they need to have a personal.xls in the first place. you can just
start to record a macro, and store it into the personal.xls , then stop the
recording to create it\

Regards,

Peo Sjoblom


"Frantic Excel-er" wrote:

> Hi all,
>
> I have written a macro that I would like to email to all of my coworkers. I
> was wondering if there is a simple way to email it to them - a way that would
> not be too difficult for them to figure out how to get the macro into their
> own personal.xls folders. (don't know if it matters, but I use Microsoft
> Outlook)
>
> Thanks in advance!!!!!!

Thanks a bunch Peo......I will try them all to see which is easiest to do,
and then I will go from there.

"Peo Sjoblom" wrote:

> You can copy the code from the VBE and paste into notepad and save with the
> extension bas, attach the *.bas file then they can import it using the same
> VBE into their personal.xls. Or you could just copy and paste the code into
> outlook and they can high light and copy it, open the VBE insert a new module
> into personal.xls and paste it into there. Of course for all of this to
> happen they need to have a personal.xls in the first place. you can just
> start to record a macro, and store it into the personal.xls , then stop the
> recording to create it\
>
> Regards,
>
> Peo Sjoblom
>
>
> "Frantic Excel-er" wrote:
>
> > Hi all,
> >
> > I have written a macro that I would like to email to all of my coworkers. I
> > was wondering if there is a simple way to email it to them - a way that would
> > not be too difficult for them to figure out how to get the macro into their
> > own personal.xls folders. (don't know if it matters, but I use Microsoft
> > Outlook)
> >
> > Thanks in advance!!!!!!