Using VBA to open last modified folder

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,

Please Login or Register  to view this content.