How do I save data in different spreadsheets inside an excel file?

[Aman]

I am already able to save data into an excel file, but how can I instead send the data separated into segments, where each segment is placed on a different spreadsheet on the excel file I specify.

[mikeporter]

In the ActiveX examples that ship with LV there is a good example of how to control Excel. Part of the process of opening a Excel file is to open the workbook (Excel document) and then open a specific worksheet (spreadsheet).

Try experimenting with that example and you should be able to figure out how to select different worksheets. If you still have trouble give another holler.

Mike...

[rossie]

Where can I find these ActiveX examples?

[rossie]

The only examples I could find for Excel Files are on examples/comm/Excel, but they are not very useful.