J
Jens Thiel
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.
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.