No Methods/Properties Available using Excel ActiveX

[DailyDose]

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?

[zou]

Have you tried register Excel ActiveX manually?

[Kyle97330]

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:

[DailyDose]

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.

[zou]

> 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]

---

@zou wrote:

Have you tried register Excel ActiveX manually?

---

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

[DailyDose]

---

@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.

---

[zou]

Register ActiveX Controls, ActiveX Servers, and Type Libraries:

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