There are many places in the book where VBA uses specific objects that may not be loaded by default. These include ADO, ADOX, DAO, Excel, Word, PowerPoint, and MapPoint. When you see these objects in the VBA code, check in Tools→References while you are in the module to ensure that you have the objects referenced, keeping in mind that you may have more than one version available.
Get Integrating Excel and Access now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
