excel

[chasmac]

can labview control excel anon toolbars? agilent has a toolbar addon for there 8362b network analyzers that alos you to connect to the instrument over the lan and get data and put into excel. i would like to have labview control the excel work set and get data from the network analyzer and then save the excel file. students usually save the data in spreadsheet format then use excell or matlab to reduce the data having excell get the data and then save the file would save some time(labview will also be controling a 3 axis drive )

charlie

afit

[smercurio_fc]

You probably could via ActiveX, but I think a better solution would be to get the data from LabVIEW in the first place and then save it in spreadsheet format from there. This would eliminate the hassle of trying to use the ActiveX interface to fiddle with the toolbar. You can get drivers for that instrument here.

As for the Matlab stuff you can have LabVIEW call the Matlab script directly once you've saved the data, or you can use Mathscript. If the code isn't that complicated you can probably rewrite it in G, and you have an all-in-one solution that doesn't deal with several different applications.

Just a thought.

[chasmac]

thanks for the input

i currently have a vi that collects the data using dcom and stores it with the position data. this was something a student asked if it could be done.

i will have to look into G programming and calling matlab script.

charlie