merge csv files within same folder into one master file

[dvb_24]

Hi all,

I found this nice code that merges all files in a folder into one master file.

Please Login or Register  to view this content.

It has been working fine during some time until I faced the workbook attched. If I double-click on the file then you may see that the file it's ok and all columns and rows are not equal to zero. However, when running the macro something is going wrong and the master file that is created has a lot of blanks (missing information) on it. Does anybody know what's wrong and how can I solve it?

I've been trying hard to make it work but finally I always get the same result, only the first 25 columns are filled up instead of 380.