View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Excel VBA help: Text file formatting

For clarity about the formatting being text, and requiring
re-processing...

Using a Variant array the output results like this...

RET Time Value1 Value2
0.6 30.92 269
0.6 30.99 317
0.6 32.59 302
0.6 33.26 337

...where all text is left-aligned and all numeric data is right-aligned.
The text results are like this...

RET Time Value1 Value2
0.600 30.92 269
0.600 30.99 317
0.600 32.59 302
0.600 33.26 337

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion