Vba code to open file which has current date in its name

[aman2059]

Hi All,

I am working on one vba coding and I am stucked in between and wanted help.

Through the macro, I want one file to be opened from the given location and the name of the file is in below format.

"LearnersinMandateDataExport_3657_11302015.xlsx"

In the above format only date changes every time and it would always be current date. for example - if I am running macro today. It would always contain the above name with the current date (mmddyyy). given as below for today

"LearnersinMandateDataExport_3657_01192016.xlsx"

I tried somewhat below.

"Workbooks.Open Filename:= _
"C:\Raw Data\" & Format("LearnersinMandateDataExport_3657_""mmddyyyy"")"

Thank you in advance for help.

 

[Con_vaibhav]

Hello, I want to write VBA code to open excel file with Path name as date (eg- CM\data\05_2020\) and excel file name(SD Amount_14.05.2020) with date which is todays date in both cases

Pls help me...

 

[Con_vaibhav]

Hello, I want to write VBA code to open excel file with Path name as date (eg- CM\data\05_2020\14.05.2020 ) and excel file name(SD Amount_14.05.2020) with date which is today's date in both cases

Pls help me...