Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a date in a range
Hello
I've an excep application in VSTO. In some point i want to be able to find if a perticular date is in a range. my code is: rng = rng.Find( date, Type.Missing, Excel.XlFindLookIn.xlFormulas, Type.Missing, Type.Missing, Excel.XlSearchDirection.xlNext, Type.Missing, Type.Missing, Type.Missing); where rng is a well defined Excel.Range(i've checked it) and date is my DateTime object to find. This method find always returns null... i guess that's hapenning 'cause diferences in date formats from c# and Excel. Can you help me here... how can i search a range for a date?! i'm loosing my mind over here best regards Jorge |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a date in a range
Try casting date to a long,Excel stores dates as long.
-- __________________________________ HTH Bob "Jorge Ribeiro" wrote in message ... Hello I've an excep application in VSTO. In some point i want to be able to find if a perticular date is in a range. my code is: rng = rng.Find( date, Type.Missing, Excel.XlFindLookIn.xlFormulas, Type.Missing, Type.Missing, Excel.XlSearchDirection.xlNext, Type.Missing, Type.Missing, Type.Missing); where rng is a well defined Excel.Range(i've checked it) and date is my DateTime object to find. This method find always returns null... i guess that's hapenning 'cause diferences in date formats from c# and Excel. Can you help me here... how can i search a range for a date?! i'm loosing my mind over here best regards Jorge |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a date in a range
SOLVED:
I first change numberFormat of range to General and then run find method (didn't find any better way) Here's my code: input are rng (Range) anda date (date to find) object oldFormat = rng.NumberFormat; rng.NumberFormat = "General"; Excel.Range result = rng.Find(date.ToOADate(), Type.Missing, Excel.XlFindLookIn.xlFormulas, Type.Missing, Type.Missing, Excel.XlSearchDirection.xlNext, Type.Missing, Type.Missing, Type.Missing); rng.NumberFormat = oldFormat; Thanx anyway Jorge "Jorge Ribeiro" wrote: Hello I've an excep application in VSTO. In some point i want to be able to find if a perticular date is in a range. my code is: rng = rng.Find( date, Type.Missing, Excel.XlFindLookIn.xlFormulas, Type.Missing, Type.Missing, Excel.XlSearchDirection.xlNext, Type.Missing, Type.Missing, Type.Missing); where rng is a well defined Excel.Range(i've checked it) and date is my DateTime object to find. This method find always returns null... i guess that's hapenning 'cause diferences in date formats from c# and Excel. Can you help me here... how can i search a range for a date?! i'm loosing my mind over here best regards Jorge |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
Find within Date Range | Excel Discussion (Misc queries) | |||
Find by date range | Excel Programming | |||
How to find date in a range? | Excel Programming | |||
Find date and copy range based on that date | Excel Programming |