Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
dim conn as adodb.connection
set conn = new adodb.connection
with conn
.Provider = "Provider=Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=C:\excel\customers.xls; Extended Properties=Excel 9.0;"
.Open
end with
dim rst as adodb.recordset
set rst = new adodb.recordset
rst.open "Sheet1$",conn,adopendynamic,adlockoptimistic, adcmdTableDirect