Import multiple CSV excel files with different sheet name

Question

Hello everyone,

I am trying to merge multiple excel files that have CSV extension and the sheet name is different for every file. The files schema is the same.

Is there any macro that can merge multiple CSV excel files? I tried to find smth similar on  community.

Thank you in advance!

mihaicom20 · Accepted Answer

@binu_acs I found this as a solution

binu_acs · Accepted Answer

@mihaicom20 thanks I made some changes in the batch macro which i initially to only read .csv files with different sheet name