Using ODSOLE to Automate Custom Objects

In this section, I'll show you how to automate COM objects you create yourself. We'll walk through automating a library of Visual Basic functions that I've wrapped in a COM object named VBODSOLELib. Let's begin by looking at Listing 15.10, the Visual Basic source code for VBODSOLELib. (You can find the complete source code in the VBODSOLELib subfolder in the CH15 folder on the CD accompanying this book.)

Listing 15.10. The Source Code for VBODSOLELib
 Option Explicit Dim GlobalArray() As Variant Dim lGlobalArraySize As Long 'String functions Public Function VBInStrRev(strCheck As String, strMatch As String) As String VBInStrRev = InStrRev(strCheck, strMatch) End Function Public Function VBStrReverse(strIn ...

Get Guru's Guide to SQL Server Architecture and Internals, The 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.