Reading worksheets within an Excel workbook

[Gorelick]

Is it possible to extract data from different worksheets within one workbook?? I have data on 6 different sheets and would like to write a vi to combine the data.

[BJD1613]

Under the report generation toolkit there are excel specific vi's that will help you work with worksheets inside a workbook. Inside most of the report generation toolkits is an activeX structure. So if you don't have the report generation toolkit addon you can also use activeX and write your own functions. YOu can get an array of worksheets when you open an automation reference to Xcell. Hope this helps.

[Gorelick]

Great, thanks for your help!!