title: Converting .txt file directly into an array with custom delimiter
body: <p>I am converting a .txt file directly into an array in excel VBA.  The default delimiter is a "," (comma) and I need to change it to "vblf".  I am having trouble figuring out how to do that with the code I have today.</p>
  
  <p>Please help</p>
  
  <pre><code>    Const strFileName As String = [file]
      Dim CONFIGTXT(1 To 13000) As String
      Dim intFileNum As Integer
      Dim intCount As Integer
      Dim strRecordData As String
  
      intFileNum = FreeFile
      intCount = 1
      Open strFileName For Input As #intFileNum
      Do Until EOF(intFileNum) Or intCount &gt; 13000
          Input #intFileNum, strRecordData
          CONFIGTXT(intCount) = strRecordData
          intCount = intCount + 1
  
      Loop
      Close #intFileNum
  
      Range("Q2:Q" &amp; UBound(CONFIGTXT) + 1) = WorksheetFunction.Transpose(CONFIGTXT)
  </code></pre>