Automatically process one excel file at a time from a folder until all files are processed

[naveennandigam]

I have a folder with over 30-40 multi tab excel files stored on my desktop. I need to create a workflow which will do following things:

1) Read one file 

2) Append data from multiple tabs

3) Perform data transformation (remove duplicates, concat, some formulas, create file name) 

4) Generate output excel file

5) Move/delete the file original file 

and repeat #1 to #4 steps (#5 step is optional) until all 30 files are processed.

I could create a workflow to select one file and process it, I need automation to process all files without manually selecting each file.

I need this automation as I will be reaciving files to process everyday

[OTrieger · Accepted solution]

@naveennandigam 
So you already have 90% of the solution, you are missing just a few steps.

Create that workflow to handle 1 file, when done and it working well, just turn it to a batch macro.
Now what left to be done is having a Directory tool and connect the full path to the Batch Macro which will be the Control Parameter. So literally what will happen the workflow will do the same to each of the files, just ensure that the naming of the output will differ so you will not overwrite the output.

[naveennandigam]

Thank you @OTrieger for suggesting me a solution. As you said, I built a workflow to handle 1 file and made that as a macro. I am struggling to connect this macro to Directory tool and execute remaining files. I am getting   "Make sure the file path is correct" error. Can you please look at my workflows and suggest any settings or changes?

[naveennandigam]

@OTrieger - Please ignore my earlier message, I am able to figure out the Fullpath settings.

[OTrieger]

Cool 😎