title: Ignoring blank lines and spaces in text files when reading
body: <p>I have a text file with file addresses listed line by line. </p>
  
  <p>Sometimes, however, the users go in there and accidentally add a space or a blank line between the addresses and that crashes the entire code.  </p>
  
  <p>How could I avoid this when reading the file using VBA?</p>
  
  <p>This is the current block used to open the text file and read addresses line by line:</p>
  
  <pre><code>Set ActiveBook = Application.ActiveWorkbook
  
  PathFile = ActiveWorkbook.Path &amp; "\FilePaths.txt"
  Open PathFile For Input As #1
  
  Do Until EOF(1)
      Line Input #1, SourceFile            
      Set Source = Workbooks.Open(SourceFile)
  </code></pre>