vba - loop through

[jono19872006]

Hi

I have code that loops through a folder and applys formats to a set of reports located in the defined folder.
The first part of the code is below which starts the loop.
Note the fpath commented out is the hardcoded path where as the range.value is a defined range in my spreadsheet to make it more dynamic.

However i want to do multiple months at once, as these reports always have the same name, is there a way of say applying this loop to two folders at the same time?
eg fpath = range("reportsaug","reportsjuly")..... for example

I could add the whole set of code in again for the two folders but it is extremely long and would become messy (especially if i wanted to go through more than two folders)

Please Login or Register  to view this content.

[arlu1201]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.