Macro to choose folder and cycle through all files

Thanks in advance.

I have a workbook that contains many control charts and currently it requires someone to open each file in a folder to enter all the data into the workbook using a hot-key'd macro. I'd like to be able to cut down the work involved and just have the user choose the folder so that a similar macro could copy all the data into the workbook where the macros already in place would be able to compile it.

While I've seen may similar questions on this forum. This code http://www.excelforum.com/forum-rule...rum-rules.htmlappears to be what I believe I need,so I've altered it to my needs.


I'm not sure why the code below will not work:

Please Login or Register  to view this content.

It is not working because you have:

Please Login or Register  to view this content.

But you have not given x a value. So you are saying

Please Login or Register  to view this content.

I cleaned up your code below and removed the For I = 1 to x, because I don't see the need for it. You are already looping through each file with "For Each myFile in MyFolder"

Please Login or Register  to view this content.

Also, I would change the task you perform with each sheet. The way it is now, you copy the entire Summary sheet and paste it into the Paste sheet... But then this gets repeated for each workbook. This means that, in effect, only the last workbook Summary sheet values will remain in the Paste sheet. Everything else gets overwritten with each loop.

Please Login or Register  to view this content.