Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find a cell with a particular date format? | Excel Discussion (Misc queries) | |||
Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
Copy Range to new Range and keep DATE format?? | Excel Programming | |||
find and replace for date format | Excel Discussion (Misc queries) | |||
Find date and copy range based on that date | Excel Programming |