Techniques Illustrated in This Solution

[Previous] [Next]

Like the solutions you have seen so far, the Custom Function Library solution demonstrates a number of techniques. Table 11-1 lists the various techniques and the source file in which each is implemented. Although I might not discuss each technique listed here, you can use this table to find the appropriate source file and examine the implementation on your own. You can also use it as a quick reminder of the techniques illustrated in this solution.

Table 11-1. Techniques illustrated in the Custom Function Library solution.

Technique	Source File
Adding a custom function library into the Spreadsheet component.	FuncTest.frm
Implementing a simple calculation function.	CustomFunctions.cls
Exposing Microsoft VBA functions as custom functions.	CustomFunctions.cls
Working with ranges in custom functions.	CustomFunctions.cls
Retrieving a single aggregate from an OLAP cube.	CustomFunctions.cls
Designing a custom function-editing user interface for complex functions.	OLAPLookupWiz.frm, FunctionWizards.cls, OLAPLookupDef.cls
Enumerating cubes, dimensions, and members using Microsoft ActiveX Data Objects Multidimensional (ADO MD).	OLAPLookupWiz.frm