Forum Discussion
Where is the documentation for Microsoft VBScript Regular Expressions 5.5?
I cannot locate the documentation for the Microsoft VBScript Regular Expressions 5.5 Office library. I am trying to use it from within Excel. From the Developer IDE>Tools, I have this library checked. This is the DLL that resides in \Windows\System32\vbscript.dll. Every search I do points me to the .NET version, which has different methods and properties. Where is this documentation?
2 Replies
Microsoft does not provide a separate documentation specifically for the Microsoft VBScript Regular Expressions 5.5 library, as far as my knowledge is sufficient. The VBScript Regular Expressions library is a part of the Windows Script Host (WSH) and is primarily designed for scripting purposes.
However, here are links for the “VBScript documentation” from various online resources and tutorials:
Regular Expression Language - Quick Reference
The Regular Expression Object Model
VBScript’s Regular Expression Support
How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
The Complete Guide to Regex in VBA
Please note that the VBScript Regular Expressions documentation is not specifically tailored for Excel but provides information on how to use regular expressions in VBScript, which can be applied to Excel VBA as well. Some links provide practical examples and guidance for using regular expressions within Excel.
I hope that I could help you with this.
- Thanks for this. The link to The Regular Expression Object Model is for the .NET version. In this version, there is no Test() method; instead it is IsMatch(). This is one of the differences. I'm curious to know what happens if the Pattern property is set with an invalid regular expression. What does the VBScript 5.5 library do in that case? Of course, I can experiment to see how it behaves, but there's no excuse for Microsoft making this the library of choice for use in Excel and providing no documentation.
