Hello,
I've written a custom function, put it in an .xla file and loaded it into excel as an add-in. All good.
The problem I have is when I use the function in a worksheet, then port that worksheet to a different computer, the worksheet retains the path and no longer works because the path is different (different OS -- 98 to XP). I have to manually remove all the path references before using the sheet. Find-replace makes this relatively painless, but it seems like it should be altogether unnecesary.
How do you make excel drop the path? It seems like, since the add-in is loaded into excel on both computers, it should know where the file is and not need to retain the pathname within the worksheet?
Thanks,
Brett
I've written a custom function, put it in an .xla file and loaded it into excel as an add-in. All good.
The problem I have is when I use the function in a worksheet, then port that worksheet to a different computer, the worksheet retains the path and no longer works because the path is different (different OS -- 98 to XP). I have to manually remove all the path references before using the sheet. Find-replace makes this relatively painless, but it seems like it should be altogether unnecesary.
How do you make excel drop the path? It seems like, since the add-in is loaded into excel on both computers, it should know where the file is and not need to retain the pathname within the worksheet?
Thanks,
Brett