Hello, I have a workflow I want to turn into a batch macro to run multiples files through one at a time if that is the best way to go about this. I have the workflow attached and the two zip files from which I need the files run through the workflow. This workflow will be comparing data from the current month to data from the previous month and I need the workflow to match up the data based on the file name. For example, I will need the File A from the current month to be compared with the File A from the previous month, then File B from current month to be compared to File B from the previous month. If there is no match in file from current to previous, I would need that file to be skipped and not run through the workflow. If I can clarify anything please let me know.
@gabrielvilella I'm not sure how it's possible for me to input the excel input files into the workflow and have it properly output what I need i.e. File A matching up with File A, and File B matching up with File B. Then having those files go through the workflow.
The easiest way is to have the date in the file name. You get, for example, the maximum date for each file, then remove one month from it, now you have the two file names you need to compare, then just read them to compare.
