Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have the merge some date in Excel 2003 and convert the output file to a csv-file. I have made a Visual Basic program, which import the data and create a csv-file. However the csv-file must be semi-colon separated. I have changed the Regional and Language settings, so the list separator is semi-colon. I have tried to save the Excel file as csv-file manually, and the result looks OK. However, I want to use Visual Basic to do both the import of data and creation of the csv-file. The problem is that Visual Basic creates the csv-file as comma separated €“ no matter of my regional and language settings. How can I get the output file as semi-colon separated? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
export CSV file with semicolon | Excel Programming | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
Need help : Open a csv file with semicolon separation | Excel Programming | |||
save a csv file with SEMICOLON delimiters | Excel Programming | |||
ADO & semicolon delimited text file? | Excel Programming |