Trouble when saving as a .csv file

[theking]

I have a macro that producuses 12 report (one for each month).
Every report is saved both in xls format and in csv format.

But when I open one of the csv files created, all information is in the first column. They are separated with comma alright, but I want it in different columns just like the xls-file.

This is an abstract from the code:

fbook is the report I'm working with. Any help is very appreciated thanxs!

/Kjell B

Range("A1").Select
Selection.CurrentRegion.Select
Selection.NumberFormat = "General"
ChDir indatafile.Path
fbook.SaveAs "In data Forecast WBS_IO " & Format(Date, "YY") & Format(i, "00") & "F3 - " & Format(Date, "YYYY-MM-DD") & ".xls"
Range("H:S").EntireColumn.Delete
Columns(1).Delete
fbook.SaveAs "In data Forecast WBS_IO " & Format(Date, "YY") & Format(i, "00") & "F3 - " & Format(Date, "YYYY-MM-DD") & ".csv", FileFormat:=xlCSV
Sheets(1).Name = Format(Date, "YY") & Format(i, "00") & "F3"
fbook.Save
fbook.Close

[Kaak]

If you are working with a dutch excel version i might have the solution.

Change your settings to a comma for thousands an a point for decimals

[theking]

I have an english of excel, but Windows XP is in swedish and I have swedish regional settings on my computer.

[theking]

Another strange thing is that when i use File, save as in csv format, then it works. But when I use code for it does´nt.

[Kaak]

Then you can compare the files in notepad...

[theking]

Thanks for the idea!

When I save using File, save as csv command, the columns in the file are separeted with semicolon (. But when I run the macro and save as csv, the columns are separated with comma (,).

Can I change so that the columns are separated with semicolon when I run the macro?