Custom Functionality with ActiveX

Way back in Chapter 2, we looked at various methods of bringing data into your Excel projects. These ranged from using Excel's import methods to getting DAO and ADO recordsets and placing their data on your worksheets.

In our ActiveX example, we'll take one of these data-driven samples and see how they'd happen in a compiled component or DLL. Then we'll look at how we can use that compiled component to add custom functionality to our projects.

I'm including the VB 6 code, but don't worry if you're not a VB programmer. The DLLs are also included with the source files for this book, so you can access the functionality. You just won't have access to the code.

Note The supporting files and source code for this book are available at, in the Download section of this book's home page.

Was this article helpful?

0 0

Post a comment