title: VBA Excel Reading text file from certain line number onward
body: <p>say we have an external program, that writes a text file during a long calculation.
  Now, I need to read that file in order to check the status of calculation (residuals values, stop on error etc).
  The file has size of up to 1Mb. Since the program only adds new information to the end of the file, I dont want to reopen it and reread from the very beginning each time.</p>
  
  <p>Is there a way to start reading the file from a specific line number (where I stopped last time)?</p>
  
  <p>What happens to the file when it is opened in Excel for reading, and after that it is changed by the external program? EoF position shifts forward?</p>