Working with CSV files

[Guest]

Hi,
When saving a CSV file, I would like the data in the cells to be contained in double quotes ("). Any idea how to accomplish this?

TIA!

DAS

 

[Dave Peterson]

Maybe you could write a macro to format it exactly the way you want.

Here's a couple of links that may give you an idea:

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

Earl Kiosterud's:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

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

In fact, you may want to try Earl's. He has lots of options built into his
macro. You just need to run it.