I have run into a problem where the path to a XLA file is not always correct
on systems that are using a roaming profile.

When I launch Excel from my desktop the path to the XLA file is correct.

The problem occurs when Excel is launched by IE when selecting a XLS file
from a web page. I have the "Browse in same window" option turned off so
Excel is launched in its own window. The drive letter of my roaming profile
network drive (T:) is used in the path to the XLA file rather than the drive
(C:)
the XLA file is installed on.

How does Excel build the path to the XLA file? In particular how does it
pick the drive, and is there anything I can do to influence this behavior?

Thanks,

Carl

Excel gets the information for selected addins from the registry. They are
stored there with a hard path in keys with names like OPEN, OPEN1, OPEN2.
These are found under Options under the Excel key for version 11 (2003).

There is another registry key which stores all the available addins, but I
don't recall what it is at the moment.

I think you would need to use an open event to unload/load the addin you
need.

--
Regards,
Tom Ogilvy

"Carl L" wrote in message
...
I have run into a problem where the path to a XLA file is not always
correct
on systems that are using a roaming profile.

When I launch Excel from my desktop the path to the XLA file is correct.

The problem occurs when Excel is launched by IE when selecting a XLS file
from a web page. I have the "Browse in same window" option turned off so
Excel is launched in its own window. The drive letter of my roaming
profile
network drive (T:) is used in the path to the XLA file rather than the
drive
(C:)
the XLA file is installed on.

How does Excel build the path to the XLA file? In particular how does it
pick the drive, and is there anything I can do to influence this behavior?

Thanks,

Carl