title: Adding Tab character while exporting Excel files to txt
body: <p>I wrote a VBA code which takes certain rows from am Excel sheet, and writes them into a TXT file. 
  the code works great, but I have 2 problems - </p>
  
  <ol>
  <li><p>I've added the "vbTab" character between each 2 cells that I copy, and in the TXT file it looks great - but when I try opening it again in Excel, each row appears in one single cell (text only in Column A), without any spaces, and it doesn't get into the columns like it should be...</p></li>
  <li><p>In the TXT file, there's quotations (") at the start and end of each row - and it's not good for my use in the TXT files.</p></li>
  </ol>
  
  <p>Here's the code:</p>
  
  <pre><code>For i = 1 To LastRow
      For j = 1 To LastCol
          If (j = 1) And (Cells(i, 1).Value = "~") Then
              Exit For
          End If
          If Not IsInArray(j, IgnoreCol) Then
              If j = LastCol Then
                  DataLine = DataLine + Trim(Cells(i, j).Value)
              Else
                  DataLine = DataLine + Trim(Cells(i, j).Value) + vbTab
              End If
          End If
      Next j
      If (DataLine &lt;&gt; "") Then
          Write #FileNum, DataLine
          DataLine = ""
      End If
  Next i
  </code></pre>
  
  <p>Thank you!</p>