I am sourcing data from a closed workbook using ADO.

dbConnStr = "DRIVER={Microsoft Excel Driver (*.xls)};ReadOnly=1;DBQ=" & SourceFile
Set dbConn = New ADODB.Connection

dbConn.Open dbConnStr
SourceRange = "MFTP_Clients"
Set rs = dbConnection.Execute("[" & SourceRange & "]")

MFTP_Clients refers to a two-column named range on a separate worksheet - A1:B200.

I am getting an error message when setting to the recordset.
Can anyone help?

CIA,
structa