excel and word application in automation open vi

[Bob_Schor]

---

@aputman wrote:

I don't know if ActiveX is installed by default but there are other programmers tools that are not installed by default.  So my solution is to just install everything.  

---

Ha, ha, ha (as my son would say).  I install "the bare minimum" (only the tools I'm reasonably sure I'll use).  I do install the VBA tools, however, and could imagine that they might be necessary ...  [My Win 7 machine does have the Objects required].

Bob Schor

[zou]

Do you have this file:

C:\Program Files (x86)\Microsoft Office\Office1x\XLxEN32.OLB?

and this one for Word:

C:\Program Files (x86)\Microsoft Office\Office1x\MSWORD.OLB

If you do, you can manually create ActiveX object from the file.

[rishavpreet]

Hi

So I was facing the same problem with not finding the excel activeX class in labview. So here's the solution I found.

Add Automation Reference on front panel> Right click it> Select ActiveX Class>Browse>Browse (Again) >

and select these files according to your office version. Excel does not have .OLB files instead it uses executable for creating objects.

Office 2013:

"C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE"

Office 2016: 

"C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE"

It will add all the methods and properties of excel class automatically. Don't forget to switch to "All Files" while browsing.

Regards

Rishav