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

This translator is intended to be used as an educational tool to help VBA developers get familiar with JavaScript. The code for this tool is based on regex examples found from multiple sources in ...

While Excel boasts over 450+ functions, sometimes they just donâ t cut it. These built-in functions fall short when you want to automate specific tasks or perform unique calculations in your databases ...

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

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