Hi keepITcool,
Thanks for your reply.

You're spot on, the "date" element in the variant array is a string
type.

So to get this working in Excel 2003 (as I mentioned in a previous
post) I cast it to a Date using CDate and also formatted it.

This solved the problem interfacing with Excel 2003, but the problem
then manifested itself in Excel 97 which had previously worked when the
"date" element was a string type.

You're right, this is confusing.

Keeno