Loading linux text file into excel using VBA

excel, linux, vba

Solution

Linux uses a line-feed (`\n`) to denote a new line rather than the carriage return+line-feed (`\r\n`) as used by Windows so you can't use `Line input`, instead:

Open Filename For Input As #1
'//load all
buff = Input$(LOF(1), #1)
Close #1

'//*either* replace all lf -> crlf
buff = replace$(buff, vbLf, vbCrLf)
msgbox buff

'//*or* line by line
dim lines() As String: lines = split(buff, vbLf)
for i = 0 To UBound(lines)
   msgbox lines(i)
next

Problem

I have a text file created on linux, if I open it in Word pad the file appears normally. However when I open it in notepad, and when I try to load it into excel using the code below it appears as a single line. ``` ' Open the file Open Filename For Input As #1 ' Look for the Table Title Do While Not (EOF(1) Or InStr(TextLine, TableTitle) > 0) Line Input #1, TextLine Loop ``` How can I split it into the original lines? Is there an end of line seperator, that vba can use?

Original source