Hi,

I have a macro that looks in a folder to see how many excel files there is and then counts them. I'm having a problem, I dont understand how I can look through them and for each file copy the data to my active workbook. I want to write in my macro the code, so i want it to be for every workbook that opens, copy range (A1:L1) to thisworkbook. Ive tried only copy paste but its not working


The code is

Please Login or Register  to view this content.
Please Login or Register  to view this content.