Open all files in a selected folder

[boxsterman]

Hi all,

What would the code be to open/link to several files in a specfic directory and copy/link specfic cells to a worksheet.

I have to amalgamate upwords of 100 files with constantly changing file names and don't want to do it manually.

Thanks,

J.

 

[erik.van.geit]

Hi,

Have a look here:
http://www.mrexcel.com/board2/viewtopic.php?t=145246

kind regards,
Erik