ADO Connection to Excel - Finding the sheets in a workbook
Have a look at ADOX.
--
Sergei
-----------------------------------------------------
Check out HOT utilities for Access and VB developers
at www.ssw.com.au
Quote:
> Does anyone know how to open a recordset in Excel where you can
> determine/query how many sheets and names are in a spreadsheet? I have a
> good connection to Excel via VB and ADO but my app should be able to open
> "any" excel workbook and find all the sheets and then let the user select
> from a list of the sheets - Thanks in advance Scott Cleveland
