Copying Excel Macros

C

cf9034

I have created a macro in Excel that I need to share with other users in my
office. I would like to copy this macro to their pc. How can I add this
macro to their macro listing without removing what they currently have?
 
D

Dave Peterson

Create a new workbook, move all your macros into that workbook and save it as an
addin.

Provide some sort of interface to the user so that they can run the macro.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

After you distribute the addin, you can tell the users to use:
tools|addins|
to browse for it and turn it on.

In fact, if all the users have access to a common network drive, you could put
the addin in a folder on that drive and tell them to browse for that addin
(tools|addins). Then you don't have to distribute the file to any person.

And don't name it personal.xla. Only one workbook with that name can be open.
And if the user has their own personal.xla, they'll have to make a decision on
which one to use.
 
K

Kevin B

Open the workbook that has the macro and press Alt+F11 to open the VBE.
Select the module that has the macro and click on FILE in the menu and select
EXPORT FILE. In the SAVE dialog box select the destination drive/folder and
save the file. The macro module will have the same name as the module itself
with a BAS extension. You can then email the module to your users.

They, in turn, need to open Excel, go to the VBE and click FILE, IMPORT FILE
to incorporate the module. IF they're going to be putting this in their
PERSONAL.XLS file, have them unhide the PERSONAL.XLS file and import the
macro from that file.
 
C

cf9034

Thanks much!
Christine

Kevin B said:
Open the workbook that has the macro and press Alt+F11 to open the VBE.
Select the module that has the macro and click on FILE in the menu and select
EXPORT FILE. In the SAVE dialog box select the destination drive/folder and
save the file. The macro module will have the same name as the module itself
with a BAS extension. You can then email the module to your users.

They, in turn, need to open Excel, go to the VBE and click FILE, IMPORT FILE
to incorporate the module. IF they're going to be putting this in their
PERSONAL.XLS file, have them unhide the PERSONAL.XLS file and import the
macro from that file.
Click to expand...
 
C

cf9034

Thanks much!
Christine

Dave Peterson said:
Create a new workbook, move all your macros into that workbook and save it as an
addin.

Provide some sort of interface to the user so that they can run the macro.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

After you distribute the addin, you can tell the users to use:
tools|addins|
to browse for it and turn it on.

In fact, if all the users have access to a common network drive, you could put
the addin in a folder on that drive and tell them to browse for that addin
(tools|addins). Then you don't have to distribute the file to any person.

And don't name it personal.xla. Only one workbook with that name can be open.
And if the user has their own personal.xla, they'll have to make a decision on
which one to use.
Click to expand...
 
K

Kevin B

Cool approach. I've really learned from reading your post's over the last 6
months. Thanks DAve.
 
D

Dave Peterson

I think that lots of us learn from the posts of others--I know I do.

But sometimes it pays to read my suggestions--just so you can correct them!
<bg>.
 
P

PG

I saw you post and how do you get the new module to show up in the micro menu
to select it or run it?
 
Top