Sharing Macros
 

I've created a macro in Excel 2002. I need to share this macro with others.
How can I e-mail this to others for them to use?

Macros live in workbooks.

So save your macro workbook with a nice name (RussUtils.xls???)
email that workbook.
Tell your users that they can either open the workbook anytime they need the
macros.

Or they can put a copy in their XLStart folder and that workbook will open each
time they open excel--and the macros will be available for them.

(Don't use personal.xls as the name. If you do, you could be screwing up their
own personal.xls workbook--you can only have one workbook with that name open at
any time.)

Russ wrote:

I've created a macro in Excel 2002. I need to share this macro with others.
How can I e-mail this to others for them to use?

--

Dave Peterson

Russ,

I guess it depends on how large your problem is. There are a number of ways
to do it, some more technical than others.

Amongst ourselves in the the group, we often just cut and paste directly
into modules and so forth. This requires some technical ability.

Here's an example of a simpler method, but it requires the recipient to do
some work too.

Open a new workbook.
Record a macro in the source workbook, nothing special, it's just a test.
Press ALT-F11 to bring up the VB Editor.
Right click on module 1 on the left side of your screen.
Click EXPORT and save it on you machine (Don't forget where you put it).
Close the workbook without saving.

(This is where you would email the module to somebody.)

Open another new workbook. (your recipients workbook)
Press ALT-F11 to bring up the VB Editor again.
Select FILE/IMPORT and get the module you previously saved.
Close the editor. The macro is now available to the new workbook.

If you don't want your users doing that sort of thing, other alternatives
would include having them send you their file to update yourself. This is not
good if there are a lot of files to update. You could also send them a new
template. This is not good if there is a lot of data to transfer to the new
workbook. Ideally, I would create a workbook that imports the data from their
workbooks into the new one with the additional functionality. This is fine as
long as you understand the structure of their current workbooks. It also
involves some VB programming skill.


Roy

--
(delete .nospam)




"Russ" wrote:

I've created a macro in Excel 2002. I need to share this macro with others.
How can I e-mail this to others for them to use?