Exporting from Excel
 

Hi!
How do I save a quoted comma-delimited file in Excel?
I can use ActiveWorkbook.SaveAs "abc.csv" , xlCSV but that does not give me
a quoted-comma-delimited file.

On the same lines, what is the difference between the constants xlCSV and
xlCSVWindows?

Thanks in advance
Habib

Exporting from Excel
 

take a look he

http://www.mcgimpsey.com/excel/textfiles.html

In article ,
"HSalim[MVP]" wrote:

How do I save a quoted comma-delimited file in Excel?
I can use ActiveWorkbook.SaveAs "abc.csv" , xlCSV but that does not give me
a quoted-comma-delimited file.

Exporting from Excel
 

Thanks JE
I was thinking I might have to write a function - i'm grateful to you for
having it ready to use.
Regards
Habib


"JE McGimpsey" wrote in message
...
: take a look he
:
: http://www.mcgimpsey.com/excel/textfiles.html
:
: In article ,
: "HSalim[MVP]" wrote:
:
: How do I save a quoted comma-delimited file in Excel?
: I can use ActiveWorkbook.SaveAs "abc.csv" , xlCSV but that does not give
me
: a quoted-comma-delimited file.