"Jens Thiel" wrote in message
...
Hello,
I'm looking for a way to replace some worksheet functions defined in an
XLA
by native counterparts exported from an XLL add-in. When deleting the
functions from the XLA and adding them to the XLL, all existing workbooks
show "#NAME?" when recalculating these functions. I have to add that the
XLA
is not accessed as a "classic" add-in, but instead added using
Tools-References from the VBA editor.
The only way I was able to update to the new XLL function was by renaming
"'C:\Full\Path\To\AddIn\Name.xla'!FunctionName " to "SomethingSilly",
saving,
closing, reopening and again renaming "SomethingSilly" to "FunctionName".
Is
there an easier way? I'm asking since I need to upgrade a lot of
workbooks,
with some of them not available on the server (that is, the upgrade should
run at the end-user).
Every help or hint appreciated!
Jens.
--
Replace MSDN with my first name when replying to my email address!
Hmm. Let' see if I understand this. What youre saying is that you used to
have something like this
=C:\Full\Path\To\AddIn\Name.xla'!MyUdf(Param1, Param2,...)
You have since replaced the functionality in Name.xla with equal
functionality in an xll. If you have done so correctly, you don't need a
path at all. Instead, the above expression should be relaced by
=MyUdf(Param1, Param2,...)
Here's a link that shows how to replace hyperlinks:
http://www.j-walk.com/ss/excel/usertips/tip031.htm
I hope this will help.
Best Regards,
Fredrik