View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Save file with fields within quotes and comma separated

There is no built in option for this. You would have to write a macro that
writes the file in that format.

--
Regards,
Tom Ogilvy

"Alvin" wrote in message
...
I want to save a CSV or another option in MS Excel file
where all fields are separated by commas and all fields
are within quotes ("). How can I achieve this?