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

In this project, we create Excel dashboard to keep track of the performance of the organization. The Excel dashboards are macro enable with VBA scripts that execute embedded SQL queries to spool data ...

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

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

Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to prompt the user to enter a filename ...