> I'm dubious as to the rationale in regard to
Currency
and
Date
data types. TMO, the fractional portion of a
Double
exceeds the required precision for a
Date
type by several orders of magnitude. The coercion that Excel does is almost certainly just a call to
VarDateFromR8, which is the same "cast" that VBA would make (and I highly suspect that it just changes the VARENUM from VT_R8 to VT_DATE and