Getting excel sheet names with DAO 
Author Message
 Getting excel sheet names with DAO

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



Sun, 26 Aug 2001 03:00:00 GMT  
 Getting excel sheet names with DAO
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


Tue, 28 Aug 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Getting excel sheet names with DAO

2. Getting the list of Excel Sheet Names using VBA

3. getting the name of the active sheet (Excel)

4. getting sheet name in excel

5. Getting Excel worksheet names using DAO.

6. DAO connecting to Excel sheet

7. DAO crashes when writing to a excel sheet with macros

8. getting previous cell values in excel sheets

9. Getting the RIGHT Excel sheet with OLE automation - AddOLEObj

10. how getting data from EXCEL.sheets

11. VB 3.0 PRO/EXCEL/DDE Getting info from different sheets

12. Excel Sheet Name

 

 
Powered by phpBB® Forum Software