Create csv file with double quotes on all fields

When I create csv files, I need to have all columns wrapped in double-quotes. Currently, Excel only wraps those columns that contain commas in double-quotes. I have access to both Excel 2003 and 2007. Is there a way to configure Excel to wrap all columns and if not, is there some VB magic that I can run to do this?

I tried to search the forum to see if this had already been discussed, but did not find anything.

Thanks,

Jack

try

Please Login or Register  to view this content.

Thanks Jindon for the code. This is working fine for the first row in my spreadsheet. However, for every other row, the resulting csv file starts with a comma. For instance, my original file has 3 rows with 3 columns each:

apple smith 100
pear jones 20
orange jackson 120

After running your code, the resulting csv file has:

"apple","smith","100"
,"pear","jones","20"
,"orange","jackson","120"

The commas that begin rows 2 and 3 are not supposed to be there.

Thanks, Jack

try

Please Login or Register  to view this content.

Thanks Jindon,

That works!!

Jack