Regular expression functions adapted from python's re library. Several functions that can be used from a worksheet once the add-in is enabled. The Regex Builder Form, a GUI for building regular ...

I like to think of all the functions in this libary as foundation functions that should have been built into VB in the first place. It's broken into the following catagories: General: VBA Functions ...

Microsoft Excel allows us to create Custom Excel Functions or User Defined Functions using VBA. We can create Custom Excel Functions with the functionality we want and they can be accessed in the ...

Greg Galloway has done some really cool things on the Analysis Services Stored Procedure Project which I’ll be blogging about soon, but in the meantime as part of his research he’s found an ...

I have a text file that was produced by a Unix program in CSV format. I am trying to parse it using Excel and thought I could automate the task using Excel VBA. However, the script I wrote VBA is not ...

Tap into Outlook’s advanced e-mail and folder functions from VB Your email has been sent What do you get when you cross VB code and Outlook 2000? A slick enterprise app. Check out these examples and ...