name definition
 

Set db = DAO.opendatabase(ThisWorkbook.FullName, 0, 0, "excel 8.0;")
Set rs = db.openrecordset("select * from [sheet2$]")
this is code about sheet name(sheet2).
i want to get not sheet name but specific range or named range.


*** Sent via Developersdex http://www.developersdex.com ***

name definition
 

'specific range address.
Set rs = db.openrecordset("SELECT * FROM [SheetName$A1:E89]"
' book-level range name.
Set rs = db.openrecordset("SELECT * FROM BookLevelName"
'sheet-level range name.
Set rs = db.openrecordset("SELECT * FROM [SheetName$SheetLevelName]"

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"x taol" wrote in message
...


Set db = DAO.opendatabase(ThisWorkbook.FullName, 0, 0, "excel 8.0;")
Set rs = db.openrecordset("select * from [sheet2$]")
this is code about sheet name(sheet2).
i want to get not sheet name but specific range or named range.


*** Sent via Developersdex http://www.developersdex.com ***

name definition
 

thank you very much, Bob Phillips !

*** Sent via Developersdex http://www.developersdex.com ***