User`s guide

Utility Library Classes
D-3
Utility Library Classes
The Excel Builder Utility Library provides several classes:
• “Class MWUtil” on page D-3
• “Class MWFlags” on page D-9
• “Class MWStruct” on page D-16
• “Class MWField” on page D-22
• “Class MWComplex” on page D-23
• “Class MWSparse” on page D-25
• “Class MWArg” on page D-28
Class MWUtil
The MWUtil class contains a set of static utility methods used in array
processing and application initialization. This class is implemented internally
as a singleton (only one global instance of this class per instance of Excel). It is
most efficient to declare one variable of this type in global scope within each
module that uses it. The methods of
MWUtil are
• “Sub MWInitApplication(pApp As Object)” on page D-3
• “Sub MWPack(pVarArg, [Var0], [Var1], … ,[Var31])” on page D-4
• “Sub MWUnpack(VarArg, [nStartAt As Long], [bAutoResize As Boolean =
False], [pVar0], [pVar1], ..., [pVar31])” on page D-6
• “Sub MWDate2VariantDate(pVar)” on page D-8
The function prototypes use Visual Basic syntax.
Sub MWInitApplication(pApp As Object)
Initializes the library with the current instance of Excel.
Parameters.
Argument Type Description
pApp Object
A valid reference to the current Excel application