Reading from Excel in Labview 6i

[FXSTB]

Hi, I am a newbie to Labview and have an old Basic version of 6i that I was playing around with trying to learn how to program with it.

I need some help reading from Excel in Labview 6i.  I have many Excel files that were generated using Labview and contain measurement data.  In each file, I want to go to a specific cell in Excel, read a value and take that value and the name of the file in which it resides and save both of those in a new Excel file that I will append other values/program names to in the future, after I run more experiments.

I saw some examples online and in the Labview 6i help area of communicating between Excel and Labview using Active X and DDE with a command line but none seem to be able to do what I want and I can't figure out how to make it do what I want.

Any help, direction in which to proceed, code examples will be very much appreciated.

Thanks.

Shai

[Chris_Cilino]

FXSTB,

If your intent is to learn LabVIEW may I suggest downloading a free 30 day trial copy of LabVIEW 8.0 and taking a look at some of our online presentations to help get you on your way. However, if you are more trying to do manipulations in Excel, I suggest looking into purchasing an upgrade to LabVIEW 8.0 and purchasing the Report Generation toolkit (released for LabVIEW version 7.1 and will be comming soon for LabVIEW version 8.0)  which already does much of what you're looking to do. If you are still intent on programming these functions, www.msdn.com has some great resources that show what ActiveX functions to call in order to accomplish what you're looking to do.

Best Regards,

Chris C

Applications Engineering

National Instruments

[Leonid Kuzmin]

I'm using 7.1, but I think, that is the same way for 6.

I just use ActiveX Container (Right Click "Insert ActiveX Object") to create the prefarence, witch is used for workin' with Excel (and many other Programs).

[Brian_Beal]

Here are some examples for Labview 6i ActiveX and Excel.  They may not be complete, but they should get you started.

[FXSTB]

Thanks for all the comments.  I will try figuring out how to use Active X because it seems to be better suited to solving my problem than other techniques I was considering.

Shai