Using VBA to open last modified folder

[scju72]

Good morning,

I'm trying to find a way to open the last modified folder on as server. I have a macro i use to locate the main folder on the server. The subfolders are based on each month of the year. So each month I run the macro i would need to open the folder with the previous months name. is there a way to find this with a wildcard or a way to select the last modified folder?

The naming conventions for the folders are as follows:

11-2014 Reports
12-2014 Reports

My macro to access the main folder is located below.

Any assistance would be greatly appreciated.

Thanks,

Sub Macro2()
'
' Macro2 Macro
'
ActiveWorkbook.FollowHyperlink Address:="\\\\dalfile1\Departments\External Reports\Public\NonPHI\Buckeye\Buckeye CFC", NewWindow:=True
'
End Sub