Regular expressions?

D

Defranco

Hi all,

Excel supports the use of Regular Expressions (RegEx) in formulas? How
do I use it?

Thanks
 
B

Bob Phillips

An example


Function ValidFileName(ByVal TheFileName As String) As Boolean
Dim RegEx As Object
Set RegEx = CreateObject("vbscript.regexp")
RegEx.Pattern = "[\\/:\*\?""<>\|]"
ValidFileName = Not RegEx.Test(TheFileName)
Set RegEx = Nothing
End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

regular expression(Regex) 6
regular expression 1
Format string using regular expression 2
Excel to check for regular expression? 7
excel and reqular expressions; what????? 1
Can someone help me with this regular expression? 3
altering dates using regular expressions? 5
Help with Regular Expression 4

Top