date format in CSV
Lets see if the problem is with writing or reading the file. Try opening the
CSV file with Notepad and see what the data looks like. Then we will know
where the problem is located.
"Helmut" wrote:
I have the following:
Range("Q1").Select
Selection.NumberFormat = "dd/mm/yyyy"
later I have this:
Range("Q1").Select
ActiveCell.FormulaR1C1 = "=EOMONTH(R1C19,0)"
The date appears correctly in the cell as i.e. "30/04/2008"
If I manually save now as test.csv file, it saves it correctly and when I
open the cell is correct.
HOWEVER
Further in the macro I have this:
ActiveWorkbook.SaveAs
Filename:="\\shekel-srv\public\Personel\2008\ToCAV" & Left(Myvalue, 2) &
Right(Myvalue, 2) & "m.csv", FileFormat:=xlCSV
When I open this file: "ToCAV0408m.csv" the cell appears: "04/30/2008"
I just cant figure out why it changes the cell content. HELP please.
|