ADO with closed workbook

I recently started working with ADO to access a closed workbook and put the retrieved data in an Array.

I have two questions regarding this:

1. How can I count the number of sheets in this closed workbook?
2. If I don't know the sheet NAME of the data sheet but I DO know it's the first sheet, how should I change this query?

Please Login or Register  to view this content.

Many thanks in advance!

Using DAO

Please Login or Register  to view this content.

Jindon, thank you for your quick reply (again)

Do you think I can combine your DAO code with my ADO code?
I already started using ADO, or do you think I only should use DAO instead...?

This is all pretty new to me ;-)

Originally Posted by jindon

I would just use the sheet name with ADO.
so the line should be like

Please Login or Register  to view this content.

Ah, didn't know I could combine them!
Thanks again man, I'll try that for sure!