Loop through folders and open folder whose name matches with yesterdays month.

[hopeful_positive]

Hello all,

I am new to VBA coding. I had taken a programming course almost 6 years ago and never touched it since but I would like to start learning slowly to automate a lot of my excel stuff.


I have 18 folders at a particular location in my drive. Out of the 18 files, 12 are files with names of the months in a calendar year such as January, February, March.... etc. .. December and the rest are folders that I do not need to worry about.

Via VBA code, I am hoping to access that monthly folder only which matches the month of the previous day, for example, if today was 1st of May, I would like to loop through all the folders in that location and open/access/look within the folder whose name matches the month of yesterdays date which would be 30th of April so April folder.

Requesting your kindest help.

Thank you !

 

[John_w]

No need to loop. You can get the full path of the required month folder like this:

    Dim monthFolder As String
    monthFolder = "C:\path\to\main\folder\" & Format(Date - 1, "Mmmm")
    MsgBox monthFolder

 

[hopeful_positive]

Worked great ! Thank you so much !