Hi All,

Is there a way in which I can copy data from some named ranges in a excel
workbook without actually opening it. I have to do it through VBA. The idea
is to get the data from a file into the file which is running the VBA code.

Please help, its very urgent.

TIA
Mayank