Date format and Range.Find
 

Hello,

1. I'm parsing resultset from database to Excel. Date format from the
database is yyyy-mm-dd. If Excel (Windows) has the same format, everything
works fine. If not, Range.Find does not finds ranges with yyyy-mm-dd format,
which results in row multiplication.
Ex: return Range::Find(COleVariant(strToFind));
and
LPDISPATCH Range::Find(const VARIANT& What)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x18e, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&What);
return result;
}


2. In Excel's help for Range.Find
(http://msdn.microsoft.com/en-us/library/bb178845.aspx), there is Parameter
called SearchFormat. What is it? When it is used and why? Any example i find,
this one set to false or omitted.

Thank you.