adding tab characters to text file

[revilord]

I am simply trying to write a line of text to a file testfile.txt and put tabs in the line. How do I do this?

sample that doesn't work
a.Writeline("Add a tab between here " & "\t" & "and here")

 

[RoyVidar]

[tt]a.Writeline "Add a tab between here " & vbTab & "and here"[/tt]

Also check out the vbCr, vbLf, vbCrLf, vbNewLine constants.

Roy-Vidar

 

[PHV]

"\t"
Seems like unix style, so you may prefer Chr(9) ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[revilord]

Thanks. Problem solved. Hard to find those vb constants in the help section. Even looking up the constant by name dindn't show much.

 

[RoyVidar]

Next hint - do that after pressing F2 (object browser) ;-)

Roy-Vidar