GitHub

Data Access Layer in VBA for connecting to SQL Server

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

This Repository contains two excel files with VBA macros, and a PHP file.

Send Email Sync Sheets Excel file contains two VBA macros. One connects to a Google Sheets doc, gets the data and prints it to the cells. The second macro sends an email to the addresses using a ...
The Earth Institute Columbia University

Coding for Risk Management: SQL

SQL is the language we use to store and retrieve our data from databases. It is an essential tool that drives our businesses, research, websites, and everything else. We will install SQLite and ...
TechRepublic

5 rules for embedding strings in VBA code

Don't struggle to pass strings. Instead, apply these five simple rules when working with embedded strings in VBA. If you want to work with VBA, eventually, you’ll struggle with embedded strings. It ...