Copy diff workbooks into one workbook without opening the workbooks

[navb]

Could anyone please help me on this ? :
I have somewhere around 25 similar workbooks which I want to merge in a single sheet. I will only import 1 sheet (say sheet1) from each of those workbooks.I want to do this without opening any of the workbooks as this will save lot of time. Can this be done ? I have heard you can do this by using some ADO connection and then querying the excel database but dont know how to do this. Any help will be greatly appreciated !!

 

[Norie]

Include the single quotes just like the #s are included for the date.

WHERE[" & CURR_NAME & "]='" & s_Currency & "'"

 

[navb]

Hi
I want to get the sheetname of a csv file without opening it. How can I do this ? TIA