3 excel files , import values into one file -makro

[Sorttaaja2]

Hello!

I have three excel files , where I have to get certain values into one file. How to do this with macro?


For example, to get from file a.xlsx value in box A3 , b.xlsx b2 and c.xlsx c1-c9 into abc.xlsx column A.


Thanks

 

[Legacy 421546]

Did you Google? Here's one result:
https://www.encodedna.com/excel/copy-data-from-closed-excel-workbook-without-opening.htm

 

[Sorttaaja2]

Did you Google? Here's one result:
https://www.encodedna.com/excel/copy-data-from-closed-excel-workbook-without-opening.htm

Thanks for the link , I tried to study it but cant comprehend it yet. I guess I have to spend more time learning.
It would be cool to get a working code where I could just modify the target sectors and get the things done.