Regular expressions?

[Defranco]

Hi all,

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

Thanks

 

[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

 

[Ron Rosenfeld]

Hi all,

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

Thanks

http://support.microsoft.com/default.aspx?scid=kb;en-us;818802&Product=vbb
--ron