Scan one Excel field of multiple workbooks in a directory, Report back results

[calbrowning]

Trying to write a VI for "scanning" a directory of test data (xls wkbooks).  Just need to it report back what it finds in a user selectable field.  Stuck on what to use to open execl; do I really need to open excel to have LabView read out the cell? -Thanks 

[TCPlomp]

Yep to read an Excel file you need some ActiveX interface, the interface of Excel as it's implemented by the MS Office Report generation toolkit needs to open an Excel window.

Ton

[calbrowning]

Can I do active X stuff without MS Office Report generation toolkit?

[Kevin_S]

Hi calbrowni,

Sure, you can use ActiveX without the Report Generation Toolkit.  It's just that a lot of the background work with interfacing to Microsoft Office has been done for you in the toolkit.  You can of course create your own toolkit that does essentially the same thing.

Kevin S.

Applications Engineer

National Instruments