Hi Kishor,
See Ron de Bruin's extensive range of sample code at:
http://www.rondebruin.nl/tips.htm
See particularly:
http://www.rondebruin.nl/ado.htm
---
Regards,
Norman
"Kishor" wrote in message
...
I have to collect data from a named range e.g. "IssueQty" from more than
50
files to a worksheet. File name is 1000, 1001 etc... Is it possible
without
opening the workbook.
ThanksInAdvance
KK