How to get a excel file which contain today's date in it filename from a folder path

[Parthasarathi]

Hi All,

I need to get a excel file from a shared folder path, there are chances for multiple excel files in that folder. But I need to get the excel file which specific filename with keyword and date in the filename. Ex. "Report_Input_09042022.xlsx". 

[binuacs]

@Parthasarathi One way of doing this is with the filter tool. The formula "Report_Input_"+DateTimeFormat(DateTimeToday(),'%m%d%Y')+'.xlsx' will return your desired filter condition. 

[Parthasarathi]

@binuacs,

Could you please let me know how can I use this output from the True part with the Input Data control to read the data from it

[grazitti_sapna · Accepted solution]

@Parthasarathi , For reading this file you will have to use Macro. Attaching the macro you can use it to read the excel files after getting its name.