John,
An MVP's supposed to be "Most",
And that means trying code that you post.
It's good that you did
Else the answer was hid.
You were humble, and that I can toast.
>I just tested this further, the following code does work.
>I'm sorry I posted the wrong code, I feel like a jerk.
>But as you see by this code.
>A DateTime is the result.
>A simple TTOD() conversion,
>No other functions to consult.
>
>No need for Date1904
>But it's really an Excel call
>You can try it with oExcel.Activeworkbook.Date1904
>It's just not needed here at all.