| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkBook.Open: Problems with field separation character
I am using these lines to open a semicolon separated file:
Dim ImportFileName As String ImportFileName = Application.GetOpenFilename("CSV-files (*.csv), *.csv") Workbooks.Open Filename:=ImportFileName, Format:=6, delimiter:=";" The file is opened, but the Excel uses "," (comma) as separator. WHY! I am running Office 2000 Pro Ebbe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Field Character Changes | Setting up and Configuration of Excel | |||
| Need help : Open a csv file with semicolon separation | Excel Programming | |||
| Workbook Open macro/& Pivot Table Calculated field query | Excel Programming | |||
| Workbook Open macro/& Pivot Table Calculated field query | Excel Programming | |||
| Workbook Open macro/& Pivot Table Calculated field query | Excel Programming | |||
Threaded Mode
