Hi,

In a Excel VBA macro, I have a Date Time Picker from which I want to
read and write dates.

Properties of my DTPicker control :

..customformat =3D "dd/MM/yyyy"
..checkbox =3D true


Sub save_detail()
Dim MyDate As Date
[=2E..]
If IsDate(MainForm.txtMepDate.value) Then
MyDate =3D CDate(MainForm.txtMepDate.value)
Worksheets("donnees").Cells(flux_line, 50).value =3D MyDate
Else
Worksheets("donnees").Cells(flux_line, 50).value =3D ""
End If
[=2E..]
End Sub

Sub init_detail(selected_flux As String)
Dim MyDate As Date
[=2E..]
If IsDate(Worksheets("donnees").Cells(flux_line, 50).value)
Then
MyDate =3D CDate(Worksheets("donnees").Cells(flux_line,
50).value)
MainForm.txtMepDate.value =3D MyDate
Else
MainForm.txtMepDate.value =3D Null
End If

[=2E..]
End Sub


The part "save_detail" works good : I find in my workbook cell a valid
date "dd/MM/yyyy hh:mm:ss"

But for the init_detail, it works good until I close the workbook and
reopen it.
Values saved before I close the workbook cannot be set with
init_detail, I have the error :

Error n=B035788 : "An error occured in a call to the Windows Date and
Time Picker control"


I have tried many things I have read (window visible, change custom
format, etc.) but no solution.


Thanks for help