My apologies John,
I wans't paying enough attention to your note,
It really was a nice verse that you wrote.
Although using the same words to rhyme in the last verse,
It still came out OK (it could have been worse).
>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.
Larry Collins
TheProgrammerGuy.com