Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Thu, 26 Apr 2007 16:30:03 -0700, Dave Runyan
wrote: Thanks, Ron - as it is so often the problem was the nut holding the wheel. I "learned" my regex using a freeware utility that had slightly different syntax, so I had to convert many lines of expressions. Along the way I somehow forgot that * is an enumerator, not a character placeholder - so I was trying to capture (*) instead of (.*). As soon as I saw your fragment I realized what the problem was. Initially I ALSO had the parameters backwards in the method invocation (having the search in a proprerty, and the input and replacement strings in the call is just hard for me to grok it seems), but when I fixed that, I then made the * error and the message I got was the same, 5018, with no helpful text. Okay - thanks again for your help - I will probably be asking something again sooner than I imagine. Well, I'm glad my efforts helped point you in a useful direction. There are certainly some aspects of Regular Expressions as used in Perl, for example, that are not replicated in VB. Best wishes. --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Capture Problem | Excel Discussion (Misc queries) | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
Time capture problem | Excel Programming | |||
RegEx to parse something like this... | Excel Programming | |||
Regex Question | Excel Programming |