Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving to a text file
1260 6 2
1266 26 12 1280 10 4 128A 128A 172 12 12 1336 1336 34 16 1358 8 3 I have 4 columns of data that looks like this when saved to a text file. All compresed. 1260 6 2 1266 26 12 1280 10 4 128A 128A 172 12 12 1336 1336 34 16 1358 8 3 I would like it formated more like this when saves to a file. Excel 97. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving to a text file
Not sure if xl97 has a tab delimited option for txt files but look through
the file type save as options and if it does then that should do the trick. Regards, OssieMaxc "Fan924" wrote: 1260 6 2 1266 26 12 1280 10 4 128A 128A 172 12 12 1336 1336 34 16 1358 8 3 I have 4 columns of data that looks like this when saved to a text file. All compresed. 1260 6 2 1266 26 12 1280 10 4 128A 128A 172 12 12 1336 1336 34 16 1358 8 3 I would like it formated more like this when saves to a file. Excel 97. Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving to a text file
After reading your post, I found this
& vbTab I merged the info into one cell and used a write to file macro that exports columns .. Cells(StartIt, 12) = " " & Address & vbTab & FTotal & vbTab & FSizeX Now it looks like this. Thanks. 1260 6 2 1266 26 12 1280 10 4 128A 172 12x12 1336 34 16 1358 8 3 1360 22 10 1376 8 3 137E 8 3 1386 6 2 138C 6 2 1392 107 12x7 13FD 8 3 1405 10 4 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving to a text file
With Courier Font, it lines up perfect.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Text File | Excel Discussion (Misc queries) | |||
Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
saving an excel file as an ASCII text file without delimiters | Excel Programming |