View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.sdk
Jens Thiel[_2_] Jens Thiel[_2_] is offline
external usenet poster
 
Posts: 44
Default Replace XLA with XLL function

"Fredrik Wahlgren" wrote

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,...)


That was my initial thought, but replacing it doesn't work and you get
"#NAME?" instead. The MyUdf function from the XLL seems to be hidden by
fragements (in the workbook) of the deleted XLA equivalent. It is available
in other workbooks, and shows up in the function wizard as well.

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.


Nope, completely unrelated :-(

Any other idea?

Jens.

--
Replace MSDN with my first name when replying to my email address!