title: How to open Text File with .OpenText in VBA that starts with first column like "ID" without getting SYLK error
body: <p>I've come across a nasty little bug in Excel VBA's <code>.OpenText</code> method..  It errors on opening any text or CSV file when the first two letters are upper-case "ID".  Here is the article from MS so you know I'm not crazy: <a href="http://support.microsoft.com/kb/323626" rel="nofollow">http://support.microsoft.com/kb/323626</a></p>
  
  <p>So, I'm trying to figure out a workaround that does NOT involve copying the entire file just to re-name the first header.  I am working with some large text files and this would be an unsatisfactory last resort.</p>
  
  <p>I've tried <code>On Error Resume Next</code> before the <code>.OpenText</code> call but that didn't work..  Has anybody come across this and found a simple solution I'm missing?  Is there a way to just crack open the first line and find/replace inside of a text file?  Or extra parameters to <code>.OpenText</code> I could use?</p>