Relative Macro Assignment in Custom Menus

[fiorentico]

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/machine. Thanks


Ivo

 

[Bob Greenblatt]

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/machine. Thanks


Ivo

You should be able to use Edit-Links to update the links to your PMWB for
each user. Or, you could write an Auto Open macro to do this.