You could using ADOX, but there is a performance overhead there as well.
IMO, it is simpler to just open them, get your data, then close them, one at
a time.

--

HTH

RP

"JVLin" wrote in message
...
Find out all sheetnames for each workbook in a folder WITHOUT OPENING EACH
WORKBOOK? (I'd like to have them in a column on my worksheet for further
processing.)

Similarly, can I copy data from one workbook to another (or for that
matter
from within a workbook) WITHOUT OPENING EACH WORKBOOK?

I ask cause the opening and closing seems to take up rather a lot of
time...

Many thanks for your answers.

Regards,
JVLIN