Guru's Guide to SQL Server Architecture and Internals, The

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 ...