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

@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.