If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould

You can download the files needed for the video here:
www.wiseowl.co.uk/videos/excelvba/ado-commands.htm

www.wiseowl.co.uk - The ADO Command object essentially allows you to write SQL statements directly into your VBA code and execute them on whichever database you've connected to - powerful stuff! This video focusses on the INSERT, UPDATE and DELETE statements to allow you to modify data based on information contained in your Excel workbooks. We'll cover how to build dynamic SQL statements and how to avoid the main danger of dynamic SQL. You'll also get an idea of how transactions work in databases, allowing you to revert your data back to a previous state if things go wrong with your code!

1. Getting Started in the VB Editor
2. Writing Your First VBA Macro
3. What to do When Things Go Wrong (Errors and Debugging)
4. Buttons, Toolbars and Keyboard Shortcuts
5. Selecting Cells (Range, Cells, Activecell, End, Offset)
6. Worksheets, Charts and Sheets
7. Workbooks
8. Variables
9. Object Variables
10. Message Boxes
11. Input Boxes
12. Application.InputBox
13. With Statements
14. If Statements
15. Select Case Statements
16. Do Until and Do While Loops
17. Find and FindNext
18. For Next Loops
19. For Each Loops
20. Creating Functions
21. Error Handling (On Error, Resume, GoTo)
22. Event Procedures
23. Application Events
24. User Forms
25. Files and Folders (FileSystemObjects)
26. Text Files (FileSystemObjects)
27. File Dialogs
28. Arrays
29. Constants and Enumerations (Const, Enum)
30. Creating Word Documents
31. Creating and Updating Linked Word Tables
32. Creating PowerPoint Presentations
33. Creating Outlook Emails
34. ADO (ActiveX Data Objects) Querying a Database
35. ADO (ActiveX Data Objects) Modifying Data with Recordsets
36. ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
37. Creating Add Ins
38. Type Declarations (UserDefined Types)
39. Class Modules
40. Using Class Modules in Other Projects
41. Custom Collections
42. Typed Collections
43. Dictionaries
44. Disabling Screen Updates
45. Saving as a PDF
46. Data Labels in Scatter Charts
47. ByRef and ByVal
48. ByRef and ByVal (When to use Parentheses)
49. Making Excel Talk
50. Finding the Last Used Row, Column and Cell
51. Querying Web Pages using Query Tables
52. Browsing to Websites and Scraping a Web Page
53. Web Scraping Across Multiple Pages
54. Downloading Files from Websites
55. Introduction to Charts in VBA
56. Embedding Charts in Worksheets
57. Introduction to Pivot Tables in VBA
58. Pivot Tables using an Access Database
59. Pivot Tables using a SQL Server Database
60. Pivot Tables and Consolidation Ranges
61. PowerPivot Data Models
62. Pivot Charts
63. Pivot Table Slicers
64. Pivot Table Date Fields and Timelines
65. Introduction to Shapes
66. Formatting Shapes
67. Adding Text to Shapes
68. Working with Strings
69. Splitting Strings
70. The Join Function and Concatenating Strings
71. Replacing Strings
72. Converting the Case of Text
73. The Asc and Chr Functions
74. The IIf Function
75. The Switch Function
76. Working with Dates

Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!