Pulling data for a closed excel workbook.

[mbhatt]

Hi,

I have 10 excel files (name: 1, 2,3,etc.) in 10 different folders. I want to pull a specific range from a common worksheet name: Data from every excel file, without opening it

Ex: File 1 – data- A2:D10 , File 2 – data- A2:D10

I want to paste the values in the desired workbook name: Summary in such a way that file 1 data come first then file 2 data and so on. Can anyone help me to get a code for this. Thank you for helping!


Thanks,

MB

 

[oldbrewer]

Hi,

I have 10 excel files (name: 1, 2,3,etc.) in 10 different folders. I want to pull a specific range from a common worksheet name: Data from every excel file, without opening it

Ex: File 1 – data- A2:D10 , File 2 – data- A2:D10

I want to paste the values in the desired workbook name: Summary in such a way that file 1 data come first then file 2 data and so on. Can anyone help me to get a code for this. Thank you for helping!


Thanks,

MB

in an open workbook sheet1 in cell A1

=c:\myfolder[anotherworkbook]sheet3!B7

this will provide the value from a closed workbook