Hi,
You have to iterate through the files inside the folder and inside foreach use Excel application scope activity pass that item in the “workbookpath” which dynamically choose the file one after another .
If you want to itereat through only today’s file follow my previous post else u can set the counter=1 in the foreah and exit after that.
ashokkarale
Anil_G
Soudios
ppr
Yoichi
lrtetala
Anjani_Kapoor
sarikayaebru
rodrigo.simao
Jon_Smith