Dynamic reading of different files using directory tool and batch macro

[Vaisakh97]

Can somebody help me with a solution which can read different files from a location but would be able to handle reading of all the sheets the excel files has and also able to read csv/txt files with different delimiters. :-)

[binuacs · Accepted solution]

@Vaisakh97 try the attached workflow

[apathetichell]

@Vaisakh97 -- did you try searching for this on the community? we get this question every week. There are tons of solutions here.