calling function from excel addin

[nitin36537]

Hi

I have developed some excel function which I am saving in the same excel file & calling function as normal excel function. say oldfile.xls which contain function test()

After some time I hade developed MyFuction.XLA (ADDIN FILE)
& put the same function test()in this new file.

Now when I open my old file which contain function test() I am getting result. But when I delete this function from my oldfile.xls I get name## error. why this happen?? (when I had also open my addin file Myfunction.xla which also contain the same function test().

Thanks

Nitin Patel

 

[yakpol]

Nitin,
If from one workbook you are calling a function located in another workbook you have to specify this workbook (even if it's open workbook). The statement:

Public Function test()
    Application.Run "MyFunction.xla!test()"
end function

will do the trick.

 

[nitin36537]

Hi Yakpol

If a function is in excel addin file & that addin file is opened througn tool -> addin , then we can use that function in excel cell as built in excel function also. I think what you are saying is true whwn we want to call a sub from addin file.

My problem is for function & not for sub.


Thanks

Nitin

 

[yakpol]

Nitin,
AddIn function are accessible the worksheet. May be the problem you encountered is lying somewhere in the function itself...