It uses OLE DB under the covers and is straightforward to program. What makes the data source control valuable is that when you use it on a Microsoft Internet Information Server web page with the appropriate extensions loaded, it can use HTTP to establish a live data link back to the server. The VBA Development Environment VBA 6.0 has become an outstanding development environment, particularly with MOD loaded. But the MOD extensions take it to the next level, with fully compiled native DLLs that execute several times faster than standard macros. The DLL capability is limited to use in Office applications, but that's what the tool is all about.
Developers can share the library to get source code reuse.
The code librarian comes preloaded with useful code snippets for Office macros. I encourage you to browse it before you begin coding. The VBA code commenter helps you add sub and function headers to your code. You can specify your own template. The VBA error handler adds error handling to all your subs and functions.