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

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

Workflow

Accepted answers

grazitti_sapna

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

Read Multiple Excel Macro.yxmc

All comments

binu_acs

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

Filter_FileName.yxmd

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

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

Read Multiple Excel Macro.yxmc

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703