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.
|