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 workshee
- A1:B200.

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

CIA,
struct

--
Struct
-----------------------------------------------------------------------
Structa's Profile: http://www.excelforum.com/member.php...fo&userid=2481
View this thread: http://www.excelforum.com/showthread.php?threadid=38370