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).

I've sanitized it and replicated the problem with just a few rows. Hey, thank you I can't upload I'm too new it seems but the t1ny u3l is slash vbacsv