Thread
:
Format of CSV File in export
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
JE McGimpsey
external usenet poster
Posts: 4,624
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
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey