Labview .NET assembly usage in VBA (Excel) Methods missing

[nottilie]

HI all

I have build a .NET assembly from some Labview vi's (.NET dll Methods). I created the prototype functions and added in and outputs.

When I use the buld dll in a .NET programming language everything works perfect and even in LUA it is no problem to call the functions within the DLL.

When I register the DLL for usage (using Regasm.exe) it is also possible to load it in VBA (In my case in Excel macro).

All datatypes are declared properly but there is no Method found.

Is there someone out who has an idea where are my methods gone or what I have to do that VBA recognizes the method build into a labview .NET assembly.

Thank you in advance

Gernot

[Marian_O]

Hello Gernot,

thank you for posting at the National Instruments Forum. Unfortunately, I have not heard about this issue yet. Is it possible, that you create a small example (like a simple "Add" Method) which shows the behaviour?

Please post the DLL here and tell me, which versions of LabVIEW, .NET, Visual Studio and Excel you are using.

You wrote, that you are using "LUA". I am not familiar with this programming language, do you mean http://en.wikipedia.org/wiki/Lua_%28programming_language%29?

Best regards

[nottilie]

Dear Marian

You are right with LUA where it works perfectly. But my final goal would also to have it working in a VBA environment like excel.

Therefore I build the following example with the including screenshots.

I used Labview 10f2 and excel 2007 as well as visual studio 2008.

First I produced quick and dirty the attached project.

After building the dll I used regasm.exe to register the dll for global usage.

As I am not familiar with the regsam things I tried step by step.

See screenshots. 

regasm1 JPG (build tbl file)----> actually already in the tbl file the methodes are missing.

then regasm2 just to try if it helps and finally regasm3 to be 100% sure that it does not work.

finally I added the build *.reg entries to my registry. This also did not help to get methodes into my VBA.

In the Object catalog of VBA for Excel it only showed this, and no methods

Just do be 100% sure that it is not a fundametal problem I used Visual studio 2008 to see if the assembly is really working.

The result was the following and  everythisn was fine within VS2008.

Hope that you ore somebody out there could help me to solve this problem

Thank you all

Best regards

Gernot

[CNCBERT]

Hi,

I am having the same problem, but my app is totally different.

Did you find a solution that solves the missing methods?

Regards,

Bert

[nottilie]

I am sorry but up to now there is no idea about the usage of LV .NET dlls in VBA.

Hopefully there is a solution at some point. I am still waiting.

Best regards

Gernot