the SourceRange must have a format like
"sheet1$A2:D100"

note the $ is used as the pipe.
the rangeref must be A1 relative notation.

"Build like this...

Set rngQry = Range("A1:d100")
strqry = rngQry.Worksheet.Name & "$" & _
rngQry.Address(0, 0, xlA1)



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


graham d wrote:

Heres my query

I have a closed work book I wish to extract results from into my open
workbook

1. I know the path where the closed spreadsheet file lives
2. I know the sheet name and cell that i want to read into my recordset

however!! NB This sheet is sent to me by someone external and there are
no named ranges in it.