Exporting from Excel

[HSalim[MVP]]

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

 

[JE McGimpsey]

take a look here:

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

 

[HSalim[MVP]]

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


: take a look here:
:
: http://www.mcgimpsey.com/excel/textfiles.html
:
: In article <[email protected]>,
:
: > 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.