Hi All,

Now i get the excel sheetnames using the Ado command
openschema(adschematable). but because i can open a recordset on a specific
location in the table using DOA i want to switch to DAO (ISAM problem).
Can anyone tell me how to extract the table names with DAO.

thanks in advance,

Sander Janssen

For I = 0 to DB.TableDefs.Count
  Debug.Print DB.TableDefs(I).Name
Next I
see utana's VB algorithm lab
http://www.utana.com