Exporting from Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry



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


.



Relevant Pages

  • Re: Exporting from Excel
    ... > 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 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Broken examples
    ... print "Procesing file:", csv ... wb.SaveAs(csv, xlCSV) ... MSDN has rather extensive documentation on the Excel object model, although it is somewhat spread out. ... # substituted for list generation ...
    (comp.lang.python)
  • Re: Broken examples
    ... wb.SaveAs(csv, xlCSV) ... MSDN has rather extensive documentation on the Excel object model, although it is somewhat spread out. ... Workbooks can be closed, but exit is something that applies to the application. ...
    (comp.lang.python)
  • Re: Excel ActiveX SaveAs interface
    ... where 6 is the Excel constant conformable to xlCSV. ... invoke%Writes a binary excel file to the csv filename ... invoke%writes an xls file to myfile.csv, and writes xls to xlCSV as well ...
    (comp.soft-sys.matlab)
  • Re: Excel ActiveX SaveAs interface
    ... where 6 is the Excel constant conformable to xlCSV. ... invoke%Writes a binary excel file to the csv filename ... invoke%writes an xls file to myfile.csv, and writes xls to xlCSV as well ...
    (comp.soft-sys.matlab)