calling function from excel addin
calling function from excel addin
(OP)
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
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
RE: calling function from excel addin
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.
RE: calling function from excel addin
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
RE: calling function from excel addin
AddIn function are accessible the worksheet. May be the problem you encountered is lying somewhere in the function itself...