VERSION 5.00 Begin {AC0714F6-3D04-11D1-AE7D-00A0C90F26F4} dsrInstallerExcel ClientHeight = 7440 ClientLeft = 0 ClientTop = 0 ClientWidth = 7305 _ExtentX = 12885 _ExtentY = 13123 _Version = 393216 Description = "Creates a report in Excel showing the installation state for all Office features." DisplayName = "Generate Windows Installer Report" AppName = "Microsoft Excel" AppVer = "Microsoft Excel 9.0" LoadName = "Load at next startup only" LoadBehavior = 16 RegLocation = "HKEY_CURRENT_USER\Software\Microsoft\Office\Excel" End Attribute VB_Name = "dsrInstallerExcel" Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = True Attribute VB_PredeclaredId = False Attribute VB_Exposed = True Option Explicit Implements IDTExtensibility2 Private WithEvents p_ctlButtonEvents As Office.CommandBarButton Attribute p_ctlButtonEvents.VB_VarHelpID = -1 Private p_strProgID As String Private Sub IDTExtensibility2_OnConnection(ByVal Application As Object, _ ByVal ConnectMode As AddInDesignerObjects.ext_ConnectMode, _ ByVal AddInInst As Object, _ custom() As Variant) ' Call shared code to create new command bar button ' and return reference to it. Assign reference to ' event-ready CommandBarButton object declared by using the ' WithEvents keyword in the Declarations section of this ' module. Set p_ctlButtonEvents = CreateAddInCommandBarButton(Application, ConnectMode, _ AddInInst) ' Set ProgID property for class. Me.ProgID = AddInInst.ProgID End Sub Private Sub IDTExtensibility2_OnDisconnection(ByVal RemoveMode _ As AddInDesignerObjects.ext_DisconnectMode, _ custom() As Variant) ' Call common procedure to unload add-in. RemoveAddInCommandBarButton RemoveMode End Sub Private Sub IDTExtensibility2_OnStartupComplete(custom() As Variant) ' End Sub Private Sub IDTExtensibility2_OnAddInsUpdate(custom() As Variant) ' End Sub Private Sub IDTExtensibility2_OnBeginShutdown(custom() As Variant) ' End Sub Public Property Let ProgID(strProgID As String) ' Write-once property is set from OnConnection event. If Len(p_strProgID) = 0 Then p_strProgID = strProgID End If End Property Public Property Get ProgID() As String ProgID = p_strProgID End Property Private Sub p_ctlButtonEvents_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean) ' Call initialization code to make sure that VBA projects ' are saved and renamed from the default. Call CreateInstallerReport End Sub