ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't always find XLA file (https://www.excelbanter.com/excel-discussion-misc-queries/25132-cant-always-find-xla-file.html)

Carl L

Can't always find XLA file
 
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


All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com