Format of CSV File in export

K

karenmiddleol

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
 
I

Ian

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

karenmiddleol

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
 
I

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export / Import 0
export to CSV file 4
csv format is wrong in Denmark 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
CSV file containing Thai characters does not load into right colum 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
.csv Re-Format Question 1
How to remove character format under .csv? 0

Top