excel - vbNewline vs Chr(10) as linebreak delimiter in Windows vs. Mac OSX - Stack Overflow
As John mentioned in the comments, the two operating systems have different NewLine character. And hence before you split it, check for which character is present and then split it. For example newL = InStr(1, CSV, vbNewLine) vbChrTen = InStr(1, CSV, Chr(...