How to get data from other Excel file

[fah]

Hi, I don't know VBA, but I urgently need to have simply macro which works like:

1. Get data from cells eg. B1-B20 from OTHER Excel file* (Sheet2)
2. Insert these extracted data to active Excel document.

*the name of the file is not constant - it has todays's date in a filename, eg. Document-21.12.2013.xlsx

Could anybody please write steps above in efficient VBA code for Excel? Many thanks!

[john55]

I used this, you can try it to see if it help you!

Please Login or Register  to view this content.

[fah]

Thank you John! Code looks interesting and would be also useful. But I don't want to select a file manualy, I would like to make file extracted automatically in defined folder (the name of the file to import is not constant because it includes todays date). How to implement this rules to the code? Again thank you very much for all solutions!

[john55]

You're welcome. I am sure someone else will help you!

[fah]

Does anybody has any idea/solution how to improve the code?

[xlbiznes]

You need just change this line of @john55

this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

change the folder path to the folder of your source file.

[fah]

Looks great! Thank you Xlbiznes!

[fah]

Just one question. The code above (by john55) works great, but it closes file, from which data has been copied. I would like to not close the file. So I tried to delete the line:
wbCopyFrom.Close SaveChanges:=False
but when I delete the line, macro doesn't work. What can I do?

[john55]

the wkb remains open if you delete that line.