Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I try to export my data from Excel 2003 to a CSV file. I use "German/ Deutsch" regional settings (so a semicolon ";" is my list separator) but changed the decimal point and group character to be "." for decimal point and "," for group as in English/US regional settings. I need to do this, to import the data in an ORACLE database. When doing a Save-As from the menu this works, but not in a macro. I found the postings about using "Local:=true" as additional parameter for SaveAs method. But still no luck. Excel ignores this and still exports using a comma "," as the field delimiter. Any idea what goes wrong? TIA, Stefan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel not using regional settings | Excel Discussion (Misc queries) | |||
Regional settings | Excel Worksheet Functions | |||
regional settings | Excel Worksheet Functions | |||
Regional Settings | Excel Discussion (Misc queries) | |||
Put one of the Regional Settings in a variable | Excel Programming |