LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

No Methods/Properties Available using Excel ActiveX

Hey Everyone.  I've got an Excel template and I'm filling in cells with data.  Pretty simple, I've done this before.

 

However, the ActiveX property and invoke nodes are showing no methods and no properties.

 

Using Windows 10, Latest Excel (and yes, it's installed), LabVIEW 2019

 

Am I missing something?  Is modern Excel only driven by .NET now?  Which assembly would one use to drive Excel with .NET?

0 Kudos
Message 1 of 8
(2,416 Views)

Have you tried register Excel ActiveX manually?

 

George Zou
0 Kudos
Message 2 of 8
(2,395 Views)

Someone suggested running a repair of your Office install might fix it. 

 

In my office it seems to work like "magic"... sometimes it'll work on a PC, sometimes it won't.  I have a desktop where it doesn't work and a laptop where it does.

 

You can use .NET though.  The "Microsoft.Office.Interop.Excel" assembly has basically the same stuff as the ActiveX did, plus a few extra things:

 

Kyle97330_0-1604598218614.png

 

Message 3 of 8
(2,378 Views)

The Report Generation VIs seem to work just fine filling in stuff.  A little complicated.  Can't just simply put value into cell and make sure value is of specific data type.  The curious thing is that I thought these Report Generation VIs used Active X.  Maybe I'm wrong about that.

0 Kudos
Message 4 of 8
(2,366 Views)

The curious thing is that I thought these Report Generation VIs used ActiveX.  

They are.

 

If that's the case, maybe you made a mistake in your VI.

Please post your VI.

 

George Zou
0 Kudos
Message 5 of 8
(2,363 Views)

@zou wrote:

Have you tried register Excel ActiveX manually?

 


Honestly don't know how to go about that.  Mind offering some guidance?

0 Kudos
Message 6 of 8
(2,363 Views)

@zou wrote:

The curious thing is that I thought these Report Generation VIs used ActiveX.  

They are.

 

If that's the case, maybe you made a mistake in your VI.

Please post your VI.

 


DailyDose_0-1604606721224.png

 

0 Kudos
Message 7 of 8
(2,359 Views)

Register ActiveX Controls, ActiveX Servers, and Type Libraries:

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z0000019MOqSAM&l=en-US

 

 

 

George Zou
Message 8 of 8
(2,355 Views)