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.

"Daren" wrote:

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.

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?

"Duke Carey" wrote:

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.

"Daren" wrote:

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.

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.

ToolsMacroRecord 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

On Tue, 21 Aug 2007 09:04:01 -0700, Daren
wrote:

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?

"Duke Carey" wrote:

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.

"Daren" wrote:

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.

Thanks. I will try that.

"Gord Dibben" wrote:

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.

ToolsMacroRecord 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

On Tue, 21 Aug 2007 09:04:01 -0700, Daren
wrote:

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?

"Duke Carey" wrote:

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.

"Daren" wrote:

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.