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
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
