Save As CSV (with "")

[mojo249]

Hi

I'm trying to write some script which will save a worksheet as a csv file. I can get it to create the csv, but the system requires that any text formatted values be enclosed by "".

So I wrote a little script which adds the "" around text values prior to saving as csv. To my bewilderment, the result was text surrounded by 3 sets of "".

So TEXT should be "TEXT" but came out """TEXT"""!

I've attached the original xls spreadsheet (Example Feeder.xls), the csv file produced by the main code below (Example Feeder.txt) and the csv prodcued by adding the code at bottom, which wraps all text values in "" prior to saving (Example Feeder (with quotes).txt).

Does anybody have any ideas what I'm doing wrong?

Dion

Please Login or Register  to view this content.

The code to add "" is as follows:

Please Login or Register  to view this content.

[pike]

Hi mojo249
do you want to save the file as a CSV or txt file?

[JBeaucaire]

Something worth reading:

http://support.microsoft.com/kb/291296

The QuoteCommaExport macro here should help.

[pike]

also this Aaron Blood and Walkenbach example

[mojo249]

Thanks to both.

That's the first time MS has managed to solve my problem.....