View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default Change a comma separated text file and save it

I don't think EXCEL will automatically save the file in your format --
their definition of "comma-delimited" isn't the old LOTUS definition.

How about writing a small subroutine to create the comma-delimited file
yourself? You just have to make sure you have the definition of each
of the 56 fields set up -- a simple case statement inside a loop should
work easily.