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:
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.![]()
Please Login or Register to view this content.
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?
Bookmarks