F
festdaddy
I'm using VBA to generate random numbers for four fields and write the
data to a text file for use in another program. I'd like the data to be
in tab-delimited format, but the WRITE statement only seems able to
produce comma delimited, and the PRINT statement only seems to produce
spaces. I've searched this group, but all the answers appear to be
related to "save as" type of solutions, which won't work for me as I'm
trying to write 100k+ lines. Is there a way to force WRITE (or PRINT)
to use tabs instead of commas (or spaces)? . is there a "/t"
equivalent type of character I can append to the data or something?
data to a text file for use in another program. I'd like the data to be
in tab-delimited format, but the WRITE statement only seems able to
produce comma delimited, and the PRINT statement only seems to produce
spaces. I've searched this group, but all the answers appear to be
related to "save as" type of solutions, which won't work for me as I'm
trying to write 100k+ lines. Is there a way to force WRITE (or PRINT)
to use tabs instead of commas (or spaces)? . is there a "/t"
equivalent type of character I can append to the data or something?