Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the VBScript_RegExp_55 library in an Excel-based VBA project to
build a text-file processor that uses rules stored in an Excel spreadsheet. I have used Regex utilities before, so I understand the concepts of text capture and re-use in a Regex expression. But when I try to capture text with (*), for example, and then try to re-use it with \1, I get either no changes made, or an object-generated error 5081. I have not been able to isolate when these two results occur. I believe my program code is basically correct, because I can do search and replace type stuff just fine, including in the same "run" as the capture operations that fail. Here are my options settings: objRgx.IgnoreCase = False ' Set case sensitive. objRgx.Global = True ' Set replace all. objRgx.MultiLine = True ' Set multiline mode. Thanks for any help you can provide. |
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 |