calling function from excel addin

nitin36537 · Mar 11, 2002

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 · Apr 1, 2002

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:

Code:

Public Function test()
    Application.Run &quot;MyFunction.xla!test()&quot;
end function

will do the trick.

nitin36537 · Apr 1, 2002

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 · Apr 2, 2002

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

calling function from excel addin

nitin36537

Civil/Environmental

yakpol

Structural

nitin36537

Civil/Environmental

yakpol

Structural

Similar threads

Part and Inventory Search

Sponsor