How to use ADO and VBA to Read from Worksheets

How to use ADO and VBA to read from worksheets

The one big advantage of ADO is that is allows to easily read data from closed workbooks.

So what is ADO. ADO is ActiveX Data Objects which help use to read from databases and other data sources. It is a programming library that does all the hard work for us as it provides a common interface for us to talk to all our data sources.

In this video I am going to show you the different ways you can harness the power of ADO with lots of examples.


DOWNLOAD THE SOURCE CODE FOR THIS VIDEO HERE: bit.ly/3GWkgfK

FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: (bit.ly/2MXsnz9)

Excel VBA Training
The Excel VBA Handbook Course(TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(excelmacromastery.com/excel-vba-webinars/)

Free Excel VBA Resources
Excel VBA Articles (excelmacromastery.com/vba-articles/)

Related Links
Connection Strings (connectionstrings.com/ace-oledb-12-0/)
VBA Class Modules – The Ultimate Guide (excelmacromastery.com/vba-class-modules)
Using ADO and SQL (bit.ly/2Sk9Qjs)

Useful VBA Shortcut Keys:
Shift + F2: Get the definition of the item under the cursor.
Ctrl + Shift + F2: Go to the last cursor position.
Ctrl + Space: AutoComplete Word.
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + R: View the Project Explorer Window.
F4: View the Properties Window.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.
Tab: To move lines of code to the right(Indent).
Shift + Tab: To move lines of code to the left(Outdent).