|don't rename the files to ".xls" extension. make it ".csv", and put commas between each field (in front of the TAB, unless you remove the tabs entirely). A fairly simple batchfile can replace the tabs with commas:|
for /f "tokens=1-3" %%a in (infile.txt) do >> outfile.csv echo %%a,%%b,%%c
(assuming you just have three fields).
Using vbscript, workbooks.openastext will allow you to open a "raw" text file, using various options. (see:
opens "Inpfile" as delimited (vs fixed-width), no quotes, tab delimited.
Then you don't have to do the csv conversion.
My version of excel is quite old, and did not support the above for testing, but it did allow this, and it worked on tab-separated fields with no surrounding quotes:
'==== begin vbscript
Set xl = WScript.CreateObject("Excel.application")
xl.Visible = TRUE