Excel VBA Functions Package for Business Data Analysts. VBA has a reputation among some for being a "step child" programming language, however it enables practitioners to deliver real value to their ...

VBA_Foundation_Functions A Repo of VBA functions I have written over the years that provide a powerful base for VBA Development. I like to think of all the functions in this libary as foundation ...

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

These built-in functions fall short when you want to automate specific tasks or perform unique calculations in your databases. Here is where the magic of VBA (Virtual Basic for Applications) comes in.

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