Question

Locked

User Defined Function (UDF) on a network

By arizenn ·
I have created a UDF and an Excel Add-in which contains this function. I want to call this function on a spreadsheet that can be viewed by anyone in my group on our network. The problem is that even if others have the add-in installed, Excel changes the function call so that it includes the full path name of the Excel Add-in. This means that Excel now looks for the add-in and function on my computer instead of looking at the add-ins installed on the other computer.

For example I want to call a function called rkdays()

If I write in cell C4 "=rkdays(...)" the function works fine. When I save it and someone else opens it they see in cell C4
"'C:\Documents and Setting\....\rk.xla'!rkdays(...)"

The path above is for my computer however and so it is simply not found. If you delete the path the function works just fine. I would like Excel not to write that path in the first place.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums