Relative Macro Assignments in Custom Menus
 

Hi,

I am trying to import some menus and the corresponding macros assigned
to them from one machine to another. As so, I am over-writing my
PERSONAL.xls file (that is where my macros are stored) and also
over-writing my Excel11.xlb menu file.

The menus pop on the new machine but upon trying to run my macros, I
get a failure. Under the menu buttons, Excel looks for the macros in:

C:\Documents and Settings\"username1"\Application
Data\Microsoft\Excel\PERSONAL.xls

However, on the new machine the location of PERSONAL.xls changes since
there is a different user, "username2". Is there a way to assign a
relative location for the macros? I want Excel to look for the macros
in "PERSONAL.xls" regardless of the user. Thanks


Ivo

Relative Macro Assignments in Custom Menus
 

I would think that if you tell it that 'username2' is in the path on the new
machine, that it would put the macros where you want them, or am I missing
something?

" wrote:

Hi,

I am trying to import some menus and the corresponding macros assigned
to them from one machine to another. As so, I am over-writing my
PERSONAL.xls file (that is where my macros are stored) and also
over-writing my Excel11.xlb menu file.

The menus pop on the new machine but upon trying to run my macros, I
get a failure. Under the menu buttons, Excel looks for the macros in:

C:\Documents and Settings\"username1"\Application
Data\Microsoft\Excel\PERSONAL.xls

However, on the new machine the location of PERSONAL.xls changes since
there is a different user, "username2". Is there a way to assign a
relative location for the macros? I want Excel to look for the macros
in "PERSONAL.xls" regardless of the user. Thanks


Ivo