This project is a Data Access layer that can be used in any VBA application to connect to SQL Server. The purpose is to keep database connectivity tidy and core database commands centralized within a ...

The Excel dashboards are macro enable with VBA scripts that execute embedded SQL queries to spool data to the different sheets of the workbook dashboards. The VBA scripts create connections to the ...

In Excel 2016, Power Query is no longer an Excel add-in but a native feature of Excel, and what’s more, you can now use VBA to create and manage Power Query queries. I’ve found two sources of ...

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

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...

Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance. I want to start off this post by thanking everyone ...

Learn how Power Query, Power Pivot, and VBA can transform your Excel skills. Choose the right tool and boost your productivity today.