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 ***