How to save a CSV?

[serdar]

I want to save a CSV file but not seperated with comma not semicolon, plus
quoted string values. How to change the settings while saving a CSV file?

 

[Dave Peterson]

You can change the separator by changing the windows list separator under
control panel regional settings (number tab).

But I'm not aware of anything that will change how quotes are applied. If excel
thinks it needs them, you get them. If excel doesn't think it needs them, you
don't get them.

But you could write your own macro to extract the data in whatever form you
want:

Some sample code to get you started:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.ht

 

[serdar]

Thanks for the help. It seems, easiest way is to write the quotes to the
cell myself Btw, I am using the csv as a simple game database file for my
site at http://onbreakgames.com/