For the Excel Application Scope, you have to give the actual file path. “*” is actually not going to work here. In case you have file names it a particular folder that change time to time, You may get the file names into an array first. And then loop through them to open the file…
I have attached a sample workflow which I created for you… This will suit the purpose of yours…