Why can Excel open up properly a badly formatted csv but vba can't?

What changes could be anything; could need

.TextFileConsecutiveDelimiter = False

Without some csv data for testing it's impossible to do analizing/debugging (just a couple of rows before and after the one that creates the problem).