How to open all excel files within a directory of folders.

[randomguy1]

Hey guys I am having difficulty with this VBA. I have gotten it to search for all excel files within a folder, but now I need it to be able to access excel files that are within folders from a parent directory. I have the following code:

Please Login or Register  to view this content.

I have it set up so that it pulls the directory name from a certain cell, which would be inputted by the operator, it works fine when I have all the spreadsheets within the same folder, but if there are folders within that folder with files I need it won't look for them.

Another problem I have is that when copying the data from the spreadsheets it does open, a pop-up comes up when copying larger amounts of data, is there any way to stop that pop-up from appearing?

[patel45]

maybe you can arrange this code

Please Login or Register  to view this content.

[randomguy1]

Thank you very much patel45!
I made a few edits, such as removing the Activeworkbook.close command because it was causing the program to close after the first paste. Also the msgbox after every file would be problematic with the number of files that we use.
Below is what I ended up with and it worked seamlessly! Again, Thank you very much!

I do have one question, I added a message box myself to tell the operator that they forgot to insert the address. Is there anyway I can conditionally stop the program if the mFolder=0? It would just be nice to not see an error message coming up after the message box?

Please Login or Register  to view this content.