VERSION 1.0 CLASS BEGIN MultiUse = -1 'True Persistable = 0 'NotPersistable DataBindingBehavior = 0 'vbNone DataSourceBehavior = 0 'vbNone MTSTransactionMode = 0 'NotAnMTSObject END Attribute VB_Name = "OfficeInstall" Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = False Attribute VB_PredeclaredId = False Attribute VB_Exposed = False Option Explicit ' This class module can be used for installing any advertised ' feature (marked "Installed on First Use" in the Office 2000 setup ' program). ' Private variables used by class. Private p_msiInst As WindowsInstaller.Installer Private p_cnnData As ADODB.Connection Private p_strDbPath As String ' Constant for name of Access database containing component ' information. Const DB_NAME As String = "PublishComponents.mdb" ' Constant for portion of ADO connection string. Const ADO_CONNECTION_STRING As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" Const ERRNUM_INVALID_FEATURE As Long = vbError + 512 Const ERRDES_INVALID_FEATURE As String = "Invalid feature." ' Enumerated constants for Office features. ' These constants are used to locate the corresponding ComponentID ' and qualifier in the PublishComponents.mdb database. ' The values in this list map to the OPGFeatureID field in the ' database. Public Enum opgInstallFeature ACCESSFiles = 1 AccessHelpFiles = 2 ACCESSNonBootFiles = 3 ACCESSSampleDBFiles = 4 ACCESSSnapshotFiles = 5 AccessUserData = 6 AccessWizards = 7 Address = 8 AntiSpam = 9 ASSISTANTClippit = 10 ASSISTANTDot = 11 ASSISTANTF1 = 12 ASSISTANTFiles = 13 ASSISTANTGenius = 14 ASSISTANTLogo = 15 ASSISTANTMotherNature = 16 ASSISTANTOffCat = 17 ASSISTANTRocky = 18 BinderFiles = 19 BinderHelpFiles = 20 BinderUserData = 21 CalendarControl = 22 ClipArt = 23 ClipAutoShapes = 24 ClipFiles = 25 ClipGalleryFiles = 26 ClipThemesAdditional = 27 ClipThemesTypical = 28 ClipThumbnails = 29 ClipThumbnailsAutoShapes = 30 ClipThumbnailsThemesAdditional = 31 ClipThumbnailsThemesTypical = 32 Contacts = 33 ConvertersFiltersFile = 34 DatabaseReplication = 35 DataMapFiles = 36 DeveloperWizards = 37 EquationEditorFiles = 38 ExcelAddinAcclinkFiles = 39 ExcelAddinATPFiles = 40 ExcelAddinAutosaveFiles = 41 ExcelAddinFiles = 42 ExcelAddinHTMLFiles = 43 ExcelAddinLookupFiles = 44 ExcelAddinODBCFiles = 45 ExcelAddinReportsFiles = 46 ExcelAddinSolverFiles = 47 ExcelAddinSumifFiles = 48 ExcelAddinTmplnumFiles = 49 ExcelAddinUpdtlinkFiles = 50 ExcelAddinWztempltFiles = 51 ExcelExpenseTemplatesFiles = 52 EXCELFiles = 53 ExcelHelpFiles = 54 ExcelInvoiceTemplatesFiles = 55 EXCELNonBootFiles = 56 ExcelPurchaseTemplatesFiles = 57 ExcelQuattroProConverterFiles = 58 ExcelSampleFiles = 59 ExcelTemplatesFiles = 60 ExcelUserData = 61 FindAllWordFormsFiles = 62 FindFastCPL = 63 FindFastFiles = 64 FPClientFiles = 65 FPClientNonBootFiles = 66 FPHelpFiles = 67 FPHtmlAdmin = 68 FPLangSupport = 69 FPSamples = 70 FPSE = 71 FPSENotInstalled = 72 FPSerk = 73 FPThemes = 74 FPTutorial = 75 FPWecCom = 76 GrammarFiles = 77 GRAPHFiles = 78 GraphHelpFiles = 79 GraphicsFiltersBMPFiles = 80 GraphicsFiltersCDRFiles = 81 GraphicsFiltersCGMFiles = 82 GraphicsFiltersEMFFiles = 83 GraphicsFiltersEPSFiles = 84 GraphicsFiltersFile = 85 GraphicsFiltersFPXFiles = 86 GraphicsFiltersGIFFiles = 87 GraphicsFiltersJPEGFiles = 88 GraphicsFiltersPCDFiles = 89 GraphicsFiltersPCXFiles = 90 GraphicsFiltersPICTFiles = 91 GraphicsFiltersPNGFiles = 92 GraphicsFiltersTIFFFiles = 93 GraphicsFiltersWMFFiles = 94 GraphicsFiltersWPGFiles = 95 HTMLSourceEditing = 96 HyphenationFiles = 97 IE3IE4Redist = 98 IE3IE4Windows = 99 InternationalSupportFiles = 100 InternationalSupportFiles_ArialUni = 101 InternationalSupportFiles_BiDi = 102 InternationalSupportFiles_CHS = 103 InternationalSupportFiles_CHT = 104 InternationalSupportFiles_JPN = 105 InternationalSupportFiles_KOR = 106 InternetExplorerSetup = 107 InternetExplorerSetupAddToMin = 108 Inventory = 109 MsInfoFiles = 110 MSVisualDesignTool = 111 Northwind = 112 NorthwindSQLProject = 113 NotInstalled = 114 OfficeCoreSupportFiles = 115 OfficeDigitalSFiles = 116 OfficeExtendedSupportFiles = 117 OfficeUserData = 118 OfficeWebComponents = 119 OrgChartFiles = 120 OSBShortCutFiles = 121 OutlookCDO = 122 OutlookDVAct3Files = 123 OutlookDVActFiles = 124 OutlookDVCsvDosFiles = 125 OutlookDVCsvWinFiles = 126 OutlookDVDbaseFiles = 127 OutlookDVEccoFiles = 128 OutlookDVExtensionsFiles = 129 OutlookDVFiles = 130 OutlookDVOrg11Files = 131 OutlookDVOrg21Files = 132 OutlookDVOrg97Files = 133 OutlookDVPabFiles = 134 OutlookDVSchplus10Files = 135 OutlookDVSchplus70Files = 136 OutlookDVSchplusinterFiles = 137 OutlookDVSK20Files = 138 OutlookDVSK95Files = 139 OutlookEFD = 140 OUTLOOKFiles = 141 OutlookFolderPublishing = 142 OutlookHelpFiles = 143 OutlookIFMSupport = 144 OutlookImpMailFiles = 145 OutlookImportExportFiles = 146 OutlookMAPI = 147 OutlookMAPICcMail = 148 OutlookMAPICONTAB = 149 OutlookMAPIEMS = 150 OutlookMAPIIMEP = 151 OutlookMAPILDAP = 152 OutlookMAPIPST = 153 OutlookMAPIPST95 = 154 OutlookMAPISFS = 155 OutlookMAPISFS95 = 156 OutlookMessaging = 157 OutlookNLST = 158 OUTLOOKNonBootFiles = 159 OutlookOMI = 160 OutlookRecall = 161 OutlookSchedulePlus = 162 OutlookSecurity = 163 OutlookStationeryBasicFiles = 164 OutlookStationeryExtendedFiles = 165 OutlookStationeryFiles = 166 OutlookTemplateFiles = 167 OutlookTimexExtensionsFiles = 168 OutlookUserData = 169 OutlookVBScript = 170 OutlookWebPub = 171 PhotoEditorFiles = 172 PowerPointUserData = 173 PPTCastCoreFiles = 174 PPTContentFiles = 175 PPTContentFilesAdditional = 176 PPTContentFilesTypical = 177 PPTConverterFLG21 = 178 PPTConverterHGDOS = 179 PPTDesignFiles = 180 PPTDesignFilesAdditional = 181 PPTDesignFilesTypical = 182 PPTFiles = 183 PPTgraphFiles = 184 PPTHelpFiles = 185 PPTNonBootFiles = 186 PPTPackngoWiz = 187 PPTSoundFiles = 188 PPTTranslatorsFiles = 189 PPTTransPP4Exp = 190 PPTTutorialFiles = 191 PPTViewerFiles = 192 ProductFiles = 193 ProductNonBootFiles = 194 ProofingToolsFiles = 195 QueryFiles = 196 ScannerCameraAddin = 197 SetLanguageFiles = 198 SpellingFiles = 199 TCExcelFiles = 200 TCLayoutFiles = 201 TCLotusFiles = 202 TCMacWordFiles = 203 TCRecoverFiles = 204 TCSearchTools = 205 TCWord2Files = 206 TCWord6ExportFiles = 207 TCWord6ExportRTFFiles = 208 TCWord6Files = 209 TCWord97Files = 210 TCWorks4Files = 211 TCWP5Files = 212 TCWP6Files = 213 TextConverters = 214 ThemesAdditionalFiles = 215 THEMESFiles = 216 ThemesTypicalFiles = 217 ThesaurusFiles = 218 TOOLSFiles = 219 VBAHelpFiles = 220 WebDiscussFiles = 221 WebPublFiles = 222 WebScripting = 223 WinFax = 224 WkgrpProps = 225 WORDAddressBookFiles = 226 WORDBordersFiles = 227 WordFaxesFiles = 228 WORDFiles = 229 WORDHelpFiles = 230 WORDHelpForWPFiles = 231 WordLettersFiles = 232 WORDMacrosFiles = 233 WordMemosFiles = 234 WORDNonBootFiles = 235 WordReportsFiles = 236 WordResumesFiles = 237 WordUserData = 238 WordWebPageFiles = 239 WORDWizAndTempFiles = 240 WordWizardsFiles = 241 AlwaysInstalled = 242 FindAllWordFormsFiles_ESN = 243 FindAllWordFormsFiles_FRA = 244 GrammarFiles_ESN = 245 GrammarFiles_FRA = 246 HyphenationFiles_ESN = 247 HyphenationFiles_FRA = 248 LotusVIMMailFiles = 249 OPCRemovePreviousMax = 250 OPCRemovePreviousMin = 251 OSESupp = 252 OutlookCcMailImporter = 253 ProofingToolsFiles_ESN = 254 ProofingToolsFiles_FRA = 255 SpellingFiles_ESN = 256 SpellingFiles_FRA = 257 TCNotesFiles = 258 ThesaurusFiles_ESN = 259 ThesaurusFiles_FRA = 260 End Enum Function InstallOfficeComponent(lngFeature As opgInstallFeature, _ Optional dctFiles As Scripting.Dictionary) As Boolean ' Installs components associated with specified feature. ' Fills Dictionary object with names of all successfully ' installed components. Dim rstData As ADODB.Recordset Dim strDbPath As String Dim strSQL As String Dim strReturn As String Dim strComponentID As String Dim strComponentQualifier As String ' Construct SQL statement. strSQL = "SELECT ComponentID, Qualifier FROM tblOfficeComponents " _ & "WHERE OPGFeatureID =" & lngFeature & ";" ' Open recordset on active connection. Set rstData = New ADODB.Recordset rstData.Open strSQL, p_cnnData, adOpenKeyset With rstData ' If recordset contains records, attempt to install each ' component in specified feature. If .RecordCount > 0 Then Do Until .EOF ' Get ComponentID. strComponentID = .Fields("ComponentID") ' Get component qualifier. strComponentQualifier = .Fields("Qualifier") On Error Resume Next ' Install component. strReturn = p_msiInst.ProvideQualifiedComponent(strComponentID, _ strComponentQualifier, MsiInstallModeDefault) If Err.Number = 0 Then If Not dctFiles Is Nothing Then ' Add file name to dictionary. dctFiles.Add Key:=strComponentQualifier, Item:=strReturn End If Else InstallOfficeComponent = False GoTo InstallOfficeComponent_End End If ' Move to next record. .MoveNext Loop Else Err.Raise ERRNUM_INVALID_FEATURE, , ERRDES_INVALID_FEATURE End If End With InstallOfficeComponent = True InstallOfficeComponent_End: rstData.Close Set rstData = Nothing Exit Function End Function Function GetFeatureInstallState(lngFeature As opgInstallFeature) As MsiInstallState ' Returns a constant indicating the installation state of ' the specified feature. Dim rstData As ADODB.Recordset Dim strDbPath As String Dim strSQL As String ' Construct SQL statement to retrieve string ' that specifies feature from database. strSQL = "SELECT Feature FROM tblFeatures " _ & "WHERE OPGFeatureID =" & lngFeature & ";" ' Open recordset. Set rstData = New ADODB.Recordset rstData.Open strSQL, p_cnnData, adOpenKeyset With rstData ' If recordset contains records, attempt to install each ' component in specified feature. If .RecordCount > 0 Then ' Check FeatureState property. Pass in the Office ' product code (which is the same for all of the Office ' applications) and the text string from the database ' that specifies the desired feature. GetFeatureInstallState = _ p_msiInst.FeatureState(Application.ProductCode, _ .Fields("Feature").Value) Else Err.Raise ERRNUM_INVALID_FEATURE, , ERRDES_INVALID_FEATURE End If End With rstData.Close End Function Function GetAllFeatureInstallStates() As ADODB.Recordset ' Returns a recordset containing strings that specify ' each feature and its installation state. ' Useful for creating a report on the installation state of ' all Office features. Dim rstData As ADODB.Recordset Dim rstReturn As ADODB.Recordset Dim fldField As ADODB.Field Dim lngState As Long Dim strSQL As String Dim strFeature As String Dim strFeatureID As String Dim strFeatureParent As String Dim strDbPath As String ' Create new recordset to hold data from table. Set rstData = New ADODB.Recordset strSQL = "SELECT FeatureParent, Feature, Title FROM tblFeatures " _ & "ORDER BY FeatureParent, Title;" ' Open recordset. rstData.Open strSQL, p_cnnData ' Create recordset to hold generated data. ' In this case, recordset acts as a data structure ' that we can populate with data dynamically. Set rstReturn = New ADODB.Recordset ' Append three text fields to the recordset. rstReturn.Fields.Append "FeatureParent", adVarChar, 255 rstReturn.Fields.Append "FeatureName", adVarChar, 255 rstReturn.Fields.Append "InstallState", adVarChar, 255 ' Open a read-write recordset. rstReturn.Open CursorType:=adOpenKeyset ' Loop through recordset containing data. With rstData Do Until .EOF ' Return name of feature's parent. This field is included ' to provide a grouping level in the resulting report. strFeatureParent = rstData.Fields("FeatureParent").Value ' If FeatureParent field contains zero-length string, ' write "{unspecified}" to recordset. If Len(strFeatureParent) = 0 Then strFeatureParent = "{unspecified}" End If ' Retrieve feature title. If it's a zero-length ' string, return string that identifies feature. strFeature = rstData.Fields("Title").Value If Len(strFeature) = 0 Then strFeature = rstData.Fields("Feature").Value End If ' Store string that identifies feature. strFeatureID = rstData.Fields("Feature").Value ' Determine installation state for feature. lngState = p_msiInst.FeatureState(Application.ProductCode, _ strFeatureID) ' Add feature and installation state information to ' rstReturn recordset. With rstReturn ' Add new record. .AddNew ' Determine installation state for feature. ' Write feature parent, feature name, and string ' indicating installation state to recordset. .Fields(0) = strFeatureParent .Fields(1) = strFeature Select Case lngState Case MsiInstallState.msiInstallStateAbsent .Fields(2) = "Absent" Case MsiInstallState.msiInstallStateAdvertised .Fields(2) = "Advertised" Case MsiInstallState.msiInstallStateBadConfig .Fields(2) = "BadConfig" Case MsiInstallState.msiInstallStateBroken .Fields(2) = "Broken" Case MsiInstallState.msiInstallStateDefault .Fields(2) = "Default" Case MsiInstallState.msiInstallStateIncomplete .Fields(2) = "Incomplete" Case MsiInstallState.msiInstallStateInvalidArg .Fields(2) = "InvalidArg" Case MsiInstallState.msiInstallStateLocal .Fields(2) = "Local" Case MsiInstallState.msiInstallStateNotUsed .Fields(2) = "NotUsed" Case MsiInstallState.msiInstallStateRemoved .Fields(2) = "Removed" Case MsiInstallState.msiInstallStateSource .Fields(2) = "Source" Case MsiInstallState.msiInstallStateSourceAbsent .Fields(2) = "SourceAbsent" Case MsiInstallState.msiInstallStateUnknown .Fields(2) = "Unknown" End Select ' Update record in rstReturn. .Update End With ' Move to next record in rstData. .MoveNext Loop ' Close rstData recordset. .Close End With ' Move to start of rstReturn recordset. rstReturn.MoveFirst ' Return rstReturn recordset. Set GetAllFeatureInstallStates = rstReturn End Function Private Sub Class_Initialize() ' Create new connection and open it on PublishComponents.mdb. Set p_cnnData = New ADODB.Connection p_strDbPath = ADO_CONNECTION_STRING & App.Path _ & Application.PathSeparator & DB_NAME p_cnnData.Open p_strDbPath ' Create new instance of Installer object. Set p_msiInst = CreateObject("WindowsInstaller.Installer") End Sub Private Sub Class_Terminate() Set p_msiInst = Nothing p_cnnData.Close Set p_cnnData = Nothing End Sub