O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required