1. from
http://www.able-consulting.com/ADO_Conn.htm#ODBCDriverForExceloConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
           "DriverId=790;" & _
           "Dbq=c:\somepath\mySpreadsheet.xls;" & _
           "DefaultDir=c:\somepath" 
2. try something like
Worksheets("Sheet2").Activate