Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export to CSV file problems
Hi all,
I have MS Excel 2002 SP3 installed. I need to create a CSV file with ~ as the delimiter. I customized my current (dutch) Regional settings List delimiter to ~. So far so good. Once I open my excel file and do a save as, select CSV file and click on Save, I have exactly what I need. Upon opening the file with Notepad, all records are separeted with ~. However, I would like to automate this. I record a macro of the above action which resulted in something like this: ActiveWorkbook.SaveAs Filename:= _ "C:\FILES\TEST.csv", _ FileFormat:=xlCSV, CreateBackup:=False But If I open that file with Notepad, all fields are separeted by comma's :-( The questions is: WHY? and how can I prevent this from happening? I want my ~ as the delimiter. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL EXPORT PROBLEMS | Excel Discussion (Misc queries) | |||
EXCEL EXPORT PROBLEMS | New Users to Excel | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
Excel file export problems | Excel Discussion (Misc queries) | |||
Problems merging an excel file due to code or file problems? | Excel Programming |