How to activate another worksheet in excel file and write data into it

[Michael Guan]

Hi,

I am writing an automation program to collect test data and write the data to an excel file.

The excel file has several worksheets and now I can only write data to one sheet. Can anyone please let me know how to activate another worksheet and write data into it? Thank you very much.

[parthabe]

You can do a search in the Example Finder for more Excel VIs.

They will give you a clearer idea of how to go about doing things in the way you need.

[smercurio_fc]

You need to access the "Sheets" property of the workbook object, and then use the "Item" method to select a specific worksheet. MSDN contains documentation on the Excel automation objects.