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 ...

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 ...

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.

An argument represents the value that you pass to a procedure parameter when you call the procedure. The calling code supplies the arguments when it calls the procedure. When you call a Function or ...

Some of you may be aware that a few VBA functions have been implemented as native MDX functions to improve performance. I blogged about this a few years ago, but I’ve now received an up-to-date list ...

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 ...

I have recently been messing with a small piece of code in VBA-Access that can send / recieve small text-strings over a network. I finally got it to work, but forgot to think ahead :facepalm: . Right ...