Trying to call a .NET function from VBA - using RUN in VBA

Question

I have a .Net class library and have done all things needed to include it in excel. (expoting as COM visible, for com-interop and regasm'ing the dll as well) I use excel 2007. In the excel addins, I see my 'TestLib.Functions' as checked. I am able to access the function in my VBA code as :

Set lib = New TestLib.Functions
returnVal = lib.Add(5);

This works fine.

For other code review reasons, I also saw some functions from another library accessed using the RUN method as :

Run("avSomeFunction", paramvalue)

Now, in the VBA editor, if I try to access the 'Add' function in the same way,

Run("Add", 5)

I get an error saying 'Cannot find a macro with name Add'. Is it neccesary that I should add tlb as a reference once again in the VB editot-tools-references again, apart from doing Regasm for the .net dll? Can someone please let me know what is the problem here.

p.s : for some very crazy reason, I just had this working once suddenly but again failed to work there after. very weird:(

please see the answer and the thread mentioned in the below answer for a more close answer to this. — Everything Matters
– Everything Matters, Commented Sep 1, 2011 at 8:32

Allen Gammel · Accepted Answer · 2011-08-19 02:42:53Z

0

Althought your question is not very straight-forward, I think that the links below will assist you in getting the solution to your problem.

First, I found a forum post explaining the same type of error you explain, "Cannot find Macro".

Second, if that doesn't work try researching using the links provided below:

If this does not solve your problem, please edit your question to include additional information.

answered Aug 19, 2011 at 2:42

Allen Gammel

3962 silver badges4 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:43:19Z

0

Difference between : adding a tlb as reference to invoke function VS using 'Run'? has the answer to this. Basically, I was missing the reference to the tlb in the VBA project. Apart from registering the dll, the tlb also needs to be added as a reference.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Sep 1, 2011 at 8:31

Everything Matters

2,7505 gold badges27 silver badges43 bronze badges

1 Comment

Everything Matters Over a year ago

marking this as answer as this thread has more information related to the same question.

Collectives™ on Stack Overflow

Trying to call a .NET function from VBA - using RUN in VBA

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related