View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_35_] Steve[_35_] is offline
external usenet poster
 
Posts: 2
Default write out a flat file with fixed columns

I would like to write a macro that writes a flat file that
is not tab or comma delimited, but has columns start at
specific locations. For example, everything in column A
of the spreadsheet will always start at column 1 of the
flat file. Everything in column B in the spreadsheet will
be written starting in column 15 of the flat file... C in
20, D in 30 ...

What is the code to place the Excel columns into the flat
file columns?

Thanks
Steve