PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes How do I E-mail a Macro to another person so that they can use it

Reply

How do I E-mail a Macro to another person so that they can use it
 
Thread Tools Rate Thread
Old 05-04-2006, 04:05 PM   #1
=?Utf-8?B?UGh5bGxpcyBLLg==?=
Guest
 
Posts: n/a
Default How do I E-mail a Macro to another person so that they can use it


I have created macros that must be used in other offices when they receive
new files. I am having difficulty sending the macros by E-mail. If I send the
Personals sheet, sometimes it is blank.
  Reply With Quote
Old 09-04-2006, 07:35 PM   #2
Nick Hodge
Guest
 
Posts: n/a
Default Re: How do I E-mail a Macro to another person so that they can use it
Phyllis

You can export macros by pressing Alt+F11 and right clickin on the macro in
the project explorer, selecting export. It exports a .bas file and this can
be imported in the same way

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Phyllis K." <Phyllis K.@discussions.microsoft.com> wrote in message
news:4E631335-7831-4629-BB26-A748F2CC7F87@microsoft.com...
>I have created macros that must be used in other offices when they receive
> new files. I am having difficulty sending the macros by E-mail. If I send
> the
> Personals sheet, sometimes it is blank.
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off