Opening multiple folders consecutively

[bocaj315]

I have a Macro that performs a variety of tasks on multiple workbooks within a folder and now I need to do this with multiple folders. So I need a loop of sorts to open a folder, then my macro will run, and then move on to another folder, then my macro will run, etc.. I looked online and found many loops for opening multiple files, but have yet to find one that works for multiple folders.

Please Help

[bocaj315]

Can someone please help?

[Alf]

Since you can't open multiple folders in Excel it's not possible to write a macro to do so untill Microsoft change this "restriction" in Excel.

Alf

[bocaj315]

Can you open one at a time and then go to the next one?

[Leith Ross]

Hello bocaj315,

Yes, you can open the folders one at a time. Are all these folders in a single parent folder or scattered around?

[bocaj315]

single parent folder

[Leith Ross]

Hello bocaj315,

That makes it easy. You can use the Dir statement to open parent folder and then the sub-folders. Do you need a code example?

[bocaj315]

Yes, that would be great.

[Leith Ross]

Hello bocaj315,

Okay, I write up a loop that open the folders in a parent folder.

[Leith Ross]

Hello bocaj315,

Here are two macro that work together. The first macro opens all the folders in the parent folder. The second macro opens all the Excel files that have ".xlsm" extensions, modifies them, and closes them. There are only comments added at this time. Once I know what you want to modify, I will change it or you can.

Please Login or Register  to view this content.

[bocaj315]

Thanks a bunch! I've modified it a bit because I want to open specific files within the subfolders but it prompts the error message that the document true.xlsx could not be found. I also tried replacing IsFolder where i have changed the font color to SubFolder and this prompted the error that it could not open the file named lots.xlsx. Just to be clear about the structure of my folders: Lots is the parent folder and within lots, there are a bunch of folders all named different things. These are the folders I need to open one by one. Within each one, I have to open a bunch of documents similar to the *_IP.csv I am trying to open here. With this code, the user will save a file to the lots file and then I would use that FilePath as the file path instead of a defined file path

Please Login or Register  to view this content.

I really do appreciate your help

[Leith Ross]

Hello bocaj315,

Can you post the entire macro code that you modified. I am having difficulty matching your comments to the code. Thanks.

[bocaj315]

Sure. I have changed the font color of the code you provided me with. So all of the wbSrc workbooks are the workbooks within the subfolders that I will open, I just need help making the loop that tells the computer to go into each subfolder. Hope this helps, let me know if you need any clarifications

Please Login or Register  to view this content.

[bocaj315]

Leith,

I understand you are very busy but I would really appreciate it if you could assist me. I provided the code you've asked for so if you need anything else, let me know.

[Leith Ross]

Hello bocaj315,

I will work on correcting your code today. It is clear from the macro you do not understand Dir function, which is why you having so many problems. You should read about this function and learn to use it correctly. Here is a link The Dir Function Explained

[bocaj315]

Thanks. You're right, I am still very new to VBA

[bocaj315]

You're right, I am still new to VBA. Have you made any progress?

[bocaj315]

Hello Leith,

Unfortunately I have been unable to figure out a solution. Have you had the opportunity to work on this code at all?