G
Guest
I open a dbf file from vba and would like to convert all date to excel
format. Does it is possible to test the dbf column format (ex: Date 8.0) ?
I have try this but doesn't work.
Thanks!
Dim Data As Date
Set rng = wks.Rows(1).Find(DateValue(Data), LookAt:=xlWhole)
If Not rng Is Nothing Then rng.EntireColumn.NumberFormat = "yyyy/mm/dd;@"
Alex St-Pierre
format. Does it is possible to test the dbf column format (ex: Date 8.0) ?
I have try this but doesn't work.
Thanks!
Dim Data As Date
Set rng = wks.Rows(1).Find(DateValue(Data), LookAt:=xlWhole)
If Not rng Is Nothing Then rng.EntireColumn.NumberFormat = "yyyy/mm/dd;@"
Alex St-Pierre