Moving a macro to other PCs

C

ChuckW

Hi,

I created a complex macro on a PC several months ago and am not sure exactly
what I did. I now need to move it to another PC. Is it possible to do this?

Thanks,
 
D

Dave Peterson

Macros live in workbooks.

So all you have to do is share the workbook with the other pc.
 
C

ChuckW

Dave,

I am a novice excel user. Can you give me more information on how to do
this? How do I find where the workbook that my macro is in is stored?

Thanks,
 
D

Dave Peterson

I don't know if I can.

Macros can be created in any workbook. You may have recorded a macro and put it
in your personal.xls file. You could have recorded the macro in the workbook
that was active.

Can you share how you run it?

While you're looking at this, try to find clues that show where that macro
lives.
Dave,

I am a novice excel user. Can you give me more information on how to do
this? How do I find where the workbook that my macro is in is stored?

Thanks,
Click to expand...
 
C

ChuckW

Dave,

I checked the macro on the PC at it is called Personal.xls!Macro1. I think
it is stored in the Personal Macro Workbook. There are three other PCs on
the same domain that I want to have this run on. It would be possible to
move this to a common folder on the network if this is possble. Otherwise it
would be great if I could just copy this macro and move it to the local
drives of the other PCs.

Thanks,
 
D

Dave Peterson

Be careful with sharing files named personal.xls.

If any of the recipients have their own personal.xls file, then your file may
overwrite their files. And if they have important stuff in their files, you
could cause heart-ache and pain.

Instead close excel.
Find that personal.xls file (use windows start button|Search)
And name it something else (ChuckWUtils.xls)

Then either move that file (or copy that file) to the network share.

Tell your users to open that file whenever they need to use the macros.


Dave,

I checked the macro on the PC at it is called Personal.xls!Macro1. I think
it is stored in the Personal Macro Workbook. There are three other PCs on
the same domain that I want to have this run on. It would be possible to
move this to a common folder on the network if this is possble. Otherwise it
would be great if I could just copy this macro and move it to the local
drives of the other PCs.

Thanks,
Click to expand...
 
G

Gord Dibben

Chuck

I prefer to leave the other Personal.xls alone.

Copy the macro from your Personal.xls to a new workbook.

To copy a macro from Personal.xls first have your new workbook open.

Hit ALT + F11 to open the VB Editor.

CTRL + r to open the Project Explorer window.

You will see your new workbook and personal.xls

Right-click on your new workbook and Insert>Module

Close that and double-click on the Module1 on Personal.xls

Copy the macro text and close the window.

Double-click on the new workbook Module1 and paste the macro in.

Save that new workbook as an Add-in under File>Save As>File type>Add-in(*.xla)

Copy that to a folder on the netword and the other users can point to that
add-in under Tools>Add-ins>Browse.

You can add more macros to the add-in as you create them.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

Some more options...

Save the file as an add (*.xla). But don't use personal.xla as the file
name--if you do that, then you may collide with a user's own personal.xla file.
(Excel can only have one file open with that name.)

Save it to a network drive and mark it readonly (using windows explorer).
Have the users do:
tools|addins and browse to that location. I'd suggest that they use the UNC
path (instead of the Mapped drive) to locate the addin.

You'll have to give the users some way to access the subroutines. (Macros in
..xla's don't show up in the tools|macro|macros dialog.)

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)
 
Top