Solved

VBA Regex String/Data Manipulation

Posted on 2006-10-24
3
616 Views
Last Modified: 2007-12-19
What's the easiest and cheapest way to do Regex (or similar) string/data manipulation in VBA.. Specifically Excel XP..
0
Comment
Question by:mortar
3 Comments
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
ID: 17801245
Hi,

The Knowledge Base entry at the VBAExpress site by regular Experts Exchange contributor matthewspatrick may be useful to you:

"UDF wrappers for RegExp Find and Replace methods"
[ http://www.vbaexpress.com/kb/getarticle.php?kb_id=841 ]

BFN,

fp.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question