How Do You Save As A CSV File That Uses ";" To Separate Values?

**np123345** · 09-01-2008, 11:11 AM

hi. please could you tell me how I can save my xls file in csv format but with ";" seperating the values. When i go to "save as > comma delemited (.csv)" or "CSV (MSDOS)" it keeps saving the excel file with commas "," instead of semi-colons ";".

Any ideas here? thanks

**np123345** · 09-01-2008, 01:45 PM

would there be like a macro that can save the the file as a CSV..

i could use this code:

.SaveAs Filename:=sFileCSV, FileFormat:=xlCSV

but is there an extra bit of coding maybe where you can specify what seperates the values? in this case i obviously need ";" semicolons to seperate the values. Please do help me. It's becoming a big headache.

Thanks a lot.

**shg** · 09-01-2008, 02:08 PM

See http://office.microsoft.com/en-us/ex...305991033.aspx

**np123345** · 09-01-2008, 04:44 PM

That's fine. Thanks. I changed my regional settings to have ";" as a seperator.
If I save manually then it works.

But if I use a macro to save (which is how i require it), then it still seperates with commas "," instead of ";".

So is there a macro code where you can specify the seperator?

Many thanks.

**shg** · 09-01-2008, 06:27 PM

You mean saving from a macro ignores the control panel settings?

**np123345** · 09-01-2008, 06:37 PM

yes excatly!

it ignores it.

i want the macro to save with ";" seperators. if i save manually then it is ok.

but the macro ignores the control panel settings!