Article ID: 163113
Article Last Modified on 10/11/2006
Sub DisplayAddins()
Dim lTotalAddins As Long
Dim oAddIn As AddIn
' Used to build the dialog box.
Dim strPrompt As String
Dim strAvailable As String
Dim strLoaded As String
Dim strTitle As String
' Get the total number of Addins.
lTotalAddins = PowerPoint.AddIns.Count
Select Case lTotalAddins
Case 0
' No add-ins are Available.
strTitle = "No Add-Ins"
strPrompt = "You currently have no PowerPoint" _
& " Add-Ins installed."
Case Else
If lTotalAddins = 1 Then
' One add-in available
strTitle = "One Add-In"
strPrompt = oAddIn.FullName
Else
' Set up the title for the dialog box.
strTitle = lTotalAddins & " Add-Ins Available"
' Set the loaded and available list.
strLoaded = "Loaded: " & Chr(13)
strAvailable = Chr(13) & "Available: " & Chr(13)
' Loop through the add-ins collection.
For Each oAddIn In PowerPoint.AddIns
If oAddIn.Loaded = msoTrue Then
strLoaded = strLoaded & Chr(9) & oAddIn.FullName _
& Chr(13)
Else
strAvailable = strAvailable & Chr(9) _
& oAddIn.FullName & Chr(13)
End If
Next oAddIn
' Combine the add-in loaded list with available add-ins
' list.
strPrompt = strLoaded & strAvailable
End If
End Select
' Display the dialog box.
MsgBox strPrompt, vbInformation, strTitle
End Sub
176476 OFF: Office Assistant Not Answering Visual Basic Questions
163435 VBA: Programming Resources for Visual Basic for Applications
Additional query words: 8.00 ppt8 vba vbe macppt mac_ppt ppt98 powerpt
Keywords: kbcode kbdtacode kbhowto kbmacro kbprogramming KB163113