Using the COM for opening Excel, can't select a particular sheet. : I am using the COM to work with Excel 2007. When I use the following code, it opens to the first sheet by default.

 Excel = Sys.OleObject("Excel.Application");

  Delay (3000); // Wait until Excel starts

  Excel.Visible = true;

  Excel.Workbooks.Open("G:\\Documentation\\CalCit Excel Files\\2004 Test Data v3 FINAL_new.xlsx");



I need to select different sheets. I tryed using the following code from the DDTdriver code.

 Excel = Sys.OleObject("Excel.Application");

  Delay (3000); // Wait until Excel starts

  Excel.Visible = true;

  Excel.Workbooks.Open("G:\\Documentation\\CalCit Excel Files\\2004 Test Data v3 FINAL_new.xlsx", "sheet2", true);

But this does not work. I have tryed many other configs and still get nothing.
