title: Loading linux text file into excel using VBA
body: <p>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.</p>
  
  <pre><code>' Open the file
  Open Filename For Input As #1
  
  ' Look for the Table Title
  Do While Not (EOF(1) Or InStr(TextLine, TableTitle) &gt; 0)
      Line Input #1, TextLine
  Loop
  </code></pre>
  
  <p>How can I split it into the original lines? Is there an end of line seperator, that vba can use?</p>