title: Convert Delimited TXT to XLS with OpenText in VBA?
body: <p>I would like to convert delimited txt into xls file. I have come up with 2 very simple line of commands which I suppose should work but in reality it didn't. Can anyone tell me what mistakes I have made?</p>
  
  <p>If this work, I am going to loop it with dir for 3000 txt files...</p>
  
  <p>Thanks!</p>
  
  <p>Bosco</p>
  
  <pre><code>Sub ConvertDelimitedTXTtoXLS()
      Dim wb As Workbooks
      wb.OpenText Filename:="C:\Users\boscotsin\Desktop\test0.txt", DataType:=xlDelimited, Tab:=True
      wb.SaveAs Filename:="C:\Users\boscotsin\Desktop\success.xls"
  End Sub
  </code></pre>