0
votes
1answer
258 views

How to Replace Words With VBScript Regex and VBA?

what is vbscript syntax for .net: \b[a-z]+\b Hi trying to replace all alpha words in the source. .net regex tester confirms this pattern will find all words: \b[a-z]+\b this: ...
1
vote
3answers
1k views

excel vba - multiline regex not working

In cell A1 of an excel sheet I have the following contents inside the cell: select a.id, b.type, c.name from blah a, blah2 b, blah3 c where a.id = b.key and b.key = c.id ; Either of the below ...
2
votes
1answer
1k views

Why does my regular expressions invoke error '5018' in my VBA script in Excel

I just wrote my first VBA script for Excel because I have to write many "*.txt" files from a folder into an excel spreadsheet. But when I run this script, I get the error '5018'. It is invoked by the ...