PC Review


Reply
Thread Tools Rate Thread

Date format and Range.Find

 
 
Alex
Guest
Posts: n/a
 
      14th Apr 2009
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Last cell in Range when range is date format default105 Microsoft Excel Misc 5 7th Jul 2009 03:11 PM
Copy Range to new Range and keep DATE format?? HammerJoe@gmail.com Microsoft Excel Programming 26 14th Jul 2008 12:19 PM
Changing the date format & adding the date range to the header =?Utf-8?B?UHVyZUV2aWw=?= Microsoft Access 1 6th Oct 2006 11:31 PM
Trying to subtract date range using General Date format =?Utf-8?B?Y29ubmll?= Microsoft Access Form Coding 1 2nd Dec 2005 09:52 PM
Find date and copy range based on that date avzundert Microsoft Excel Programming 2 25th Nov 2004 10:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:20 AM.