Easily create SQL queries and execute them on a database. For an example on how to use this library with data objects, see the VBA-Drupal-Library. For other examples on using the library, refer to the ...

The VBA SQL Client Data Integration System is designed to streamline the process of retrieving and managing client information within an organization. This project features a robust class module that ...

Learn how to streamline Excel tasks with Power Query and VBA, unlocking smarter workflows and advanced automation techniques. MS Excel 2025 ...

In some organizations, the IT department wants all interaction with the server to be done through Stored Procedure. This adds a level of risk management and makes the DBAs feel better.

The Coding for Risk Management Seminar workshops get you started in Excel, VBA, R, Python, SQL, and GitHub. The first step in all of these languages is a big step; after taking it here, you will be ...

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