Copying Excel Macros
 

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?

Copying Excel Macros
 

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.




cf9034 wrote:

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?

--

Dave Peterson

Copying Excel Macros
 

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.
--
Kevin Backmann


"cf9034" wrote:

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?

Copying Excel Macros
 

Thanks much!
Christine

"Kevin B" wrote:

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.
--
Kevin Backmann


"cf9034" wrote:

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?

Copying Excel Macros
 

Thanks much!
Christine

"Dave Peterson" wrote:

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.




cf9034 wrote:

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?

--

Dave Peterson

Copying Excel Macros
 

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


"Dave Peterson" wrote:

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.




cf9034 wrote:

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?

--

Dave Peterson

Copying Excel Macros
 

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.

Kevin B wrote:

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

"Dave Peterson" wrote:

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.




cf9034 wrote:

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?

--

Dave Peterson


--

Dave Peterson

Copying Excel Macros
 

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?

"Kevin B" wrote:

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.
--
Kevin Backmann


"cf9034" wrote:

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?