Control a LabWindows/CVI-Program by Excel(Visual Basic)

[MarkusP]

Hello,
maybe it's a very simple question, maybe it isn't possible, I don't know.
My question is, is it possible to write a macro in VBA(Excel) which control a programm written in LabWindows/CVI?
The problem is, that It isn't possible to write the whole programm in VBA/CVI. So I have to write it in both languages.
But there is the problem, that I have to control everything by Excel.
Whats the solution?
Build an ActiveX-Server and access it by Excel? Is this possible?
I hope you can help me, because I'm very new in this area.

Best Thanks and a nice evening


Markus

[JoeTestEngineer]

What you want to do is possible. You will need to create an activeX automation server in CVI or even visual C++. The methods you create in CVI/C++ will be accessible in VBA. This is the beauty of COM. COM will provide language independance. I would suggest considering ATL instead of CVI. There are lots of books avalailble that cover Microsoft's Active Template Libaries (ATL) in great detail.

[bilalD]

You can check out some of the examples includeed with CVI for create a CVI application as an activex server. You can find them under ..\samples\activex\cvi. There are some application notes on this topic as well. Check out link as well.

Hope this helps

Bilal Durrani
NI

[MarkusP]

Hi,
many thanks. Its great to know that's possible. So I can work forward, knowing there's a aim 😉

Regards Markus