Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
Writing to a text file some data | Excel Programming | |||
Open delimited text file to excel without changing data in that file | Excel Programming |