VBA Pick - two input files from a structured folder

[Mallesh23]

Hi Team,

Need help in picking latest input file and Previous Input file from a folders.

Everyday we download input file save that file in a Folder date wise.

Latest dates folder which Contains Single Input File will be :=> Current workbook.
Immediate Previous dates folder which contain Single Input file :=> is Previous workbook.

if month changes Macro should pick Previous months last folders input file as Previous workbook.


Folder structure will be as follows.

Main Folder :=> Review
Sub Folder Yearly :=> 2020 ..it will change yearly
Sub Folder Monthly :=> Aug.2020 . It will change as per month monthly
Sub Folder Date Wise :=> everyday there will be one folder and one single input file in that
a) 05.08.2020
b) 06.06.2020
c) 07.06.2020

Please suggest how to open programatically Current workbook and Previous workbook. Thanks in advance!

Also attached dummy Snapshot.



Thanks
mg