Hi all,
So my workflow finds all excel sheets in the directory
It then filters all filenames with 725 as these are only relevant to me
The macro:
Finds all sheet names of all folders within the directory as not all have the M3 Sheet I targeted.
Back to workflow:
Filters all files with sheet name M3
Creates a filepath for dynamic input to read.
This is where it gets complicated.
The workflow does its job but only scrapes the data of one file and stops because the schema differs.
I have compared the scraped file with one of the others and found the column widths to be different only.
How do I skip this error?
