Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incorrect resolution of path to XLA file when user has roaming prf
I have defined a couple of functions in a XLA file. I've registered it
through the Tools - add-ins dialog. I can successfully enter formulas in cells which call my functions. If I save the workbook and exit from Excel, and then reopen the workbook everything works as correctly. So far so good... The problem occurs when I save the xls file to a DAV repository and then access it from IE. When Excel is launched the path to the XLA file is not correct so the functions do not work. The XLA file is installed on c:\program files\... When Excel is launched from IE the path to the XLA file is set to the drive that my profile is on. If I update links and point the XLA bcak to C: the functions work properly. I've looked at the contents of the XLS file, and I see the path to the XLA file is stored in there without a drive identifier. How does Excel determine which drive to add to the path to the XLA file? How can I control this behavior? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable spreadsheet when copied to incorrect file path or differen ip address | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Incorrect templates path | Excel Programming | |||
Macros i xla-files get incorrect path | Excel Programming | |||
_How could I get the code to find out the resolution that user has in the computer | Excel Programming |