Excel VBA Code for searching and opening a file in dynamic folder path

[exodia819]

Hi Excel community,

I am a beginner in excel vba and want to ask this question. I want to be able to open the file that has selected date in it.

For an example,

Date input = May 1, 2015
Month = May (cell 1)
Date = 0501 (cell 2)


Then, run macro, it will attempt to find the folder name "May" (cell 1) and sub folder name"0501" (cell 2) and locate 'Report_05012015.xlsm' from the specified directory.

When found the specific file, open the workbook, Otherwise, open the latest dated report.

Folder path is U:\work\Report\May\0501\Report_05012015.xls

Thank you in advance,

Paul