Format of CSV File in export

[karenmiddleol@yahoo.com]

I am using the following Excel function in exporting a Excel worksheet
into a CSV file:

Sheets(1).SaveAs "c:\abc.csv", 6

The worksheet is exported successfully as a CSV file but the text
columns in the spreadsheet are correctly exported as :

Blue Film Package but the columns which are numeric are exported in the
following format:

"52,177", "1,914,446","2,166,925"

I do not want the comma 1000 seperators and the quotes in the csv file.
Appreciate if you could share the code to accomplish the export into a
; or tab or anyother character delimitation.

Thanks
Karen

[Ian]

Go to Format Cells>Number>Number and uncheck the "Use 1000 Separator box".
The save as CSV.

--
Ian
--
<karenmiddleol@yahoo.com> wrote in message
news:1126176537.883907.59730@f14g2000cwb.googlegroups.com...
>I am using the following Excel function in exporting a Excel worksheet
> into a CSV file:
>
> Sheets(1).SaveAs "c:\abc.csv", 6
>
> The worksheet is exported successfully as a CSV file but the text
> columns in the spreadsheet are correctly exported as :
>
> Blue Film Package but the columns which are numeric are exported in the
> following format:
>
> "52,177", "1,914,446","2,166,925"
>
> I do not want the comma 1000 seperators and the quotes in the csv file.
> Appreciate if you could share the code to accomplish the export into a
> ; or tab or anyother character delimitation.
>
> Thanks
> Karen
>

[karenmiddleol@yahoo.com]

I cannot do this I am saving the CSV file from a script.

Also, if possible I would like to export in tab delimited form

Thanks
karen

[JE McGimpsey]

Take a look here:

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

In article <1126176537.883907.59730@f14g2000cwb.googlegroups.com>,
karenmiddleol@yahoo.com wrote:

> I am using the following Excel function in exporting a Excel worksheet
> into a CSV file:
>
> Sheets(1).SaveAs "c:\abc.csv", 6
>
> The worksheet is exported successfully as a CSV file but the text
> columns in the spreadsheet are correctly exported as :
>
> Blue Film Package but the columns which are numeric are exported in the
> following format:
>
> "52,177", "1,914,446","2,166,925"
>
> I do not want the comma 1000 seperators and the quotes in the csv file.
> Appreciate if you could share the code to accomplish the export into a
> ; or tab or anyother character delimitation.
>
> Thanks
> Karen

[Ian]

The code saves the CSV, but the CSV only has 1000 delimiters in it because
the formatting on the sheet is like that. Can't you change the sheet
formatting before running the code?

--
Ian
--
<karenmiddleol@yahoo.com> wrote in message
news:1126185840.580900.55330@o13g2000cwo.googlegroups.com...
>I cannot do this I am saving the CSV file from a script.
>
> Also, if possible I would like to export in tab delimited form
>
> Thanks
> karen
>