macro that reads all the files in a directory

[GOL]

Hello, I have a macro that reads all the sheets in the fileonea (Table of Query: List of Sheet Names).

The action tool Update the Value as follow: 

But I also need that the macro reads all the files (fileonea, filetwoa, filefoura) in the directory :

So, I have created a workflow that starts with directory tool and receives the macro :

For some reason, the workflow doesnt work and I have to upload manually all the files one by one in the macro detailed before. I have tried some different options but with no result. 

Would you mind explaining me how read automatically all the files in a directory?. 

I think that it could be that the macro receives the list of sheet names but the directory has the path or the filename but not the list of sheet names...i guess

Your help is much appreciated. 

Regards, 

[BS_THE_ANALYST · Accepted solution]

@GOL You can use this workflow: 

Just remember to select FullPath on the macros inside the Questions Tab. I just leave all the Group By as none:

Let me know how it goes.

All the best,
BS

[shekhar198569]

Hi, it gives this error while running workflow