| 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 |
| 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) | |||
Threaded Mode
