By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 426 - public gADO As ADODB.Connection

This statement declares a public variable aka Global variable as an ADO (Active Data Objects) Connection object.

This object allows you to connect to a database and run queries.

What is ADO?

What is ODBC?

What is a connection?

Do I have to know this?

Not really, if you use the routines in the ExpertAtExcel Module, it handles the details of connecting to a database.

Connecting to a database is where the system sign's in and sets up a path so that you can run queries against it.