Importing Macros

D

Daren

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.
 
D

Duke Carey

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.
 
D

Daren

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?
 
G

Gord Dibben

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
 
D

Daren

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