Pull data from closed workbooks in same folder

[ceytl]

Hello,

I have been looking for VBA script that can go into all the closed .xlsx files in a folder called S1 and grab the data from cells B5, H7, F19, F20, F21, and then put these values in A2, B2, C2, D2, E2

There is about 100 files, and the path is: c:\Users\US\Desktop\S1

is this something that can be done?

Thanks,

 

[johnnyL]

@ceytl Just delete that line.

        SourcefileName = Replace(SourcefileName, "-", "''")