Dynamic Input: Extract Files of COB Date yesterday

[bubblyjai1982]

Hi All,

Kindly help in extracting the multiple files as of COB yesterday.

The File name contain the date i.e. File name start with a prefix of Date and followed by Sec id... So on daily basis multiple files will be saved.

Example: 

20250805_EMTNUSD080633DBINL03

20250805_EMTNUSD080735DBINL02

20250804_EPTNUSD080830DBINL02

20250804_EXTNHKD060755DBINL03

20250804_EMTNEUR080830DBINL02

20250804_EMTNUSD060755DBINL03

20250801_EMTNAUD081132DBINL01

20250801_EMTNJPY081050DBINL02

20250801_EMTNUSD080940DBINL08

20250831_EMTNUSD080633DBINL03

20250831_EMTNUSD080735DBINL02

Using dynamic input tool I'm trying to extract the files of COB yesterday date i.e. 20250804

I have attached my workflow, please advise if there is any easiest way to extract the multiple files containing COB date yesterday.

Thanks

[binuacs]

If it is working for you with the input tool it should work with the dynamic input tool as well. is the sheet names are same for your input .xlsb files I mean all are having sheet1 as the sheet name?

[DawnDuong]

There were reported bugs when using Dynamic Input Tools with large / multiple .xlsb.

How to Enable Microsoft Excel Binary (XLSB), Excel Legacy (XLS), Access (ACCDB) for In/Out tools

XLSB File Crashes Designer

If all fails, perhaps you can consider doing a batch macro instead? 

Dawn.