Quote:
Originally Posted by Freex
To be truthful I just tired it with the raw txt that Geoff bundled with it (made on mac i'd assum), as I'm not connected to the studio PC atm, to take a real life example.
I was being lazy, and noisey before I head to the land of nod.
I'll connect here and give it a go.
|
Ah, cross-platform incompatibility means that if you generate the text file on a Mac, it won't import properly on Windows.
The command used in Excel VBA to import the data into the sheet doesn't recognise the Mac end-of-line (LF) properly, so it all ends up in one cell
Frankly, the cross platform thing is a bit of sh** show with Excel VBA.