In Excel how to make a worksheet as default

[hema]

Hello ,

I have a Excel file called Report.xls . In this file there are many worksheets. Everytime I open this Excel  file, i want the second sheet as the default sheet which is visible to the user. The Excel file should always open with the second sheet showing up.

Please let me know how to do it with LabVIEW. I tried all the property and methods of worksheet class but no success.

Thanks , Hema

[smercurio_fc]

You need to either:

• (simple) have the worksheet active when you save the file. The next time you open the workbook, it will open to that sheet
• (harder) use events. Specifically, respond to the WorkbookOpen open event. This involves ActiveX events. There is an example showing how to use Excel ActiveX events that ships with LabVIEW.

[Christian Mergl]

It should work as follows:

Christian