text file with tab
I would like to export some data (with tab delimiter) from excel, with
HEADER which is string, to .txt file. In exported .txt file, I get quotation
(" ") for string which I don't want. I have written:
Open "test.txt" for output as #1
print #1, "Time", tab, "Average"
for i = 1 to lastrow
Print #1, sheets("test").Cells(i,1), tab, sheets("test").Cells(i,3)
next i
I want the text file as:
Time (Tab) Average
1/1/1999 (Tab) 3.5
1/2/1999 (Tab) 5.5
Could you please help me out?
Thanks,
Nazrul
|