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
Bookmarks