Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VBA Regex String/Data Manipulation

Posted on 2006-10-24
3
Medium Priority
?
620 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 2000 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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Make the most of your online learning experience.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Simple Linear Regression

885 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