Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Format of CSV File in export
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 |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Format of CSV File in export
Go to Format CellsNumberNumber and uncheck the "Use 1000 Separator box".
The save as CSV. -- Ian -- wrote in message ups.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 |
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Format of CSV File in export
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 |
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Format of CSV File in export
Take a look he
http://www.mcgimpsey.com/excel/textfiles.html In article . 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 |
#5
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Format of CSV File in export
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 -- wrote in message ups.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I export an .xls file to Qif file format | Excel Discussion (Misc queries) | |||
How to export excel file in dbf format | Excel Discussion (Misc queries) | |||
Format of CSV File in export | Excel Discussion (Misc queries) | |||
Format of CSV File in export | Excel Worksheet Functions | |||
how do I export a worksheet as a fixed format ascii file | Excel Discussion (Misc queries) |