I don't know all the international settings but check you VBa help menu fro

FileFormat Property

the file format can be used with SAVEAS to specify the type of file you are
saving. Do you have in your worksheet menu File - SAVEAS an option to save
as semicolon delimited? If you have an option in the menu then there should
be an option in VBA SAVEAS.

"Kirchler" wrote:


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?