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
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
worksheets(变量名)select
worksheets(变量名).aciviate
变量名可以是字符,也可以是数字,字符必是sheet名