R
Russ
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?
How can I e-mail this to others for them to use?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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.)
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.)
R
Roy Wagner
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
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