Calling a Add-in function from Excel's VBA

Question

I am using an Excel Add-in for an Erlangs: http://abstractmicro.com/erlang/helppages/ref-erlbblockage.htm

I try to call the Erlang-B function within the Add-in from within VBA thus:

Function Erl(Erlangs As Double, Capacity As Double)
    Erl = Application.WorksheetFunction.ErlbBlockage(Capacity, Erlangs)
End Function

...but it doesn't work. I get #VALUE! returned in the Excel cell. I think it is because the function is not part of standard Excel (it is in the Add-in). So how do I call it?

chris neilsen · Accepted Answer · 2012-01-24 18:24:46Z

4

Try setting a reference in your VBA project to the Erlang Addin
VBE-->Tools-->References check A_Erlang

Then you can call the functions in the addin directly from VBA

Myvar = ErlbBlockage(capacity, erlangs)

edited Jan 24, 2012 at 18:24

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges

answered Jun 19, 2010 at 9:31

Charles Williams

23.6k5 gold badges40 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calling a Add-in function from Excel's VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related