Custom Add-in function carries pathname with it?

[bcruden]

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

 

[DRJ]

Hi - Welcome to the board

How are you refering to items that use the path? There is probably a better way. Post some code so we can help.

 

[bcruden]

I don't think it's the VB code, something about the workbook? Let me get more specific.

I've got my custom function (interpolate), and I refer to it in the worksheet as, for instance:

=interpolate(G2,$A$3:$A$1787,$B$3:$B$1787)

This on my WinXP machine. When I port this worksheet over to my other machine (Win 98), this becomes:

='C:\Documents and Setting...\CustomFns.xla'!interpolate(G2,$A$3:$A$1787,$B$3:$B$1787)

CustomFns.xla is installed as an add-in on both computers and is exactly the same file on both computers, just residing in different directory paths. Why does Excel retain the pathname? I never enter the pathname myself, this excel does automatically. Should I be doing something different?

Another problem unrelated, but since I'm here: My custom function tries to recalculate itself any time I change anything on the worksheet, even when the change I make does not impact this function. What's that all about?

 

[DRJ]

Application.Volatile (False)

Use that to make the function not recalculate all the time.

 

[bcruden]

Application.Volatile (False) does not seem to do anything. The function still recalculates when any cell value is changed. Any ideas?

And my question about the pathname still remains open, too...