How can I connect to an Excel file as a database using the ADO connection? The code below connect to an Access file. Do I have only to change the provider? What is the provider to an Excel file?

Set ConexaoAccess = New ADODB.Connection

With ConexaoAccess
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open ArquivoAccess
End With

Here is a list of connection strings Excel is listed in there

http://www.erlandsendata.no/english...badacconnstring
HTH

David