Leverage .NET Framework Classes From VBA

Inside the .NET regular exceptions are handled by a set of types. The entry point is the Regex Class. The class has two main methods:

IsMatch – this method checks whether or not a string matches the pattern.

Matches – find all the matches of a pattern in a string.

In this post, codeproject.com teaches you how to wrap .NET components to make it available to your VBA code. This is a simple process, and not that trivial to begin with. Building a wrapper causes less trouble than finding an existing VBA component, understanding how it works, and integrating it, without having the assurance that it works as advertised.

Read the rest of the tutorial here: http://www.codeproject.com/Articles/762426/Leverage-the-NET-framework-classes-from-VBA

Leave a Reply

Your email address will not be published. Required fields are marked *