Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can detect that setting object failed
hi
I use VB-RegEx for pattern matching. The command "set objMatched = .Excecute(SomeString)" fails if the pattern didn't match. I tried "if objMatch is Nothing then ... end if" to intercept the event; without success. Please help me with some ideas. thx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can detect that setting object failed
set objMatched = .Excecute(SomeString)"
cnt = objMatched.count if cnt = 0 then ' no matches ' else for each match in objMatched etc End if Regards, Peter T "chfa" wrote in message ... hi I use VB-RegEx for pattern matching. The command "set objMatched = .Excecute(SomeString)" fails if the pattern didn't match. I tried "if objMatch is Nothing then ... end if" to intercept the event; without success. Please help me with some ideas. thx |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can detect that setting object failed
Could it as simple as your typo in .execute????
chfa wrote: hi I use VB-RegEx for pattern matching. The command "set objMatched = .Excecute(SomeString)" fails if the pattern didn't match. I tried "if objMatch is Nothing then ... end if" to intercept the event; without success. Please help me with some ideas. thx -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can detect that setting object failed
.execute
and I've propagated it ! Peter T "Dave Peterson" wrote in message ... Could it as simple as your typo in .execute???? chfa wrote: hi I use VB-RegEx for pattern matching. The command "set objMatched = .Excecute(SomeString)" fails if the pattern didn't match. I tried "if objMatch is Nothing then ... end if" to intercept the event; without success. Please help me with some ideas. thx -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can detect that setting object failed
Hi Dave,
Could it as simple as your typo in .execute???? Of Course it's only a typo but I've regret saying that's not the answer at all. the answer was provided by Peter. Nevertheles thanks for the hint. Chris, the steppenwolf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range of Object _Global Failed | Charts and Charting in Excel | |||
Method Add of object Validation Failed - please help | Excel Worksheet Functions | |||
paste object failed | Excel Programming | |||
HELP - 'Add' of object 'CommandBarControls' failed | Excel Discussion (Misc queries) | |||
Method ~ of Object ~ Failed. | Excel Programming |