Importing Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import macros from a shared drive onto a computer so that they
are in my personal workbook each time I open Excel. At this point, each time
I work with a file, I have to import the macros, making the process lengthy.
Is there a way to import the macros from the shared drive and save in my
personal.xls file?

Thanks.
 
Assuming you already HAVE a personal.xls file - simply open the workbook with
the macros you want to use, then copy the modules from that workbook into
your personal workbook. These will be static copies - updates made to the
shared drive version will neeed to be manually updated.
 
In searching for the personal.xls file, I've tried to unhide it under Window,
but it isn't there. How can I 'install' a personal.xls file?
 
You may not have one.

If you never recorded a macro to your Personal Macro Workbook you won't.

Start up Excel and a blank workbook.

Tools>Macro>Record new macro.

When the record macro dialog opens select "Personal Macro Workbook" from "store
in" dropdown.

Do a couple of things like copy a cell from one place to another or similar.

Hit the stop recording button. Do not hit the "x" to stop recording.

You now have a Personal.xls stored in your Office XLSTART folder.

It will open hidden whenever Excel starts.

Your macros will be stored in there.

Hit Alt + F11 then CTRL + r to see the Personal.xls workbook and its modules.


Gord Dibben MS Excel MVP
 
Thanks. I will try that.

Gord Dibben said:
You may not have one.

If you never recorded a macro to your Personal Macro Workbook you won't.

Start up Excel and a blank workbook.

Tools>Macro>Record new macro.

When the record macro dialog opens select "Personal Macro Workbook" from "store
in" dropdown.

Do a couple of things like copy a cell from one place to another or similar.

Hit the stop recording button. Do not hit the "x" to stop recording.

You now have a Personal.xls stored in your Office XLSTART folder.

It will open hidden whenever Excel starts.

Your macros will be stored in there.

Hit Alt + F11 then CTRL + r to see the Personal.xls workbook and its modules.


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top