|
请问,加载宏的列表内容是否在Windows注册表里有相关键啊?
- Sub ListAddins()
- '列出加载宏
- Dim objAddin As Object
- Dim arr, i As Byte
- ReDim arr(1 To Application.AddIns.Count, 1 To 6)
- On Error GoTo ErrorHandler
- For Each objAddin In Application.AddIns
- i = i + 1
- With objAddin
- arr(i, 1) = .Name
- arr(i, 2) = .FullName
- arr(i, 3) = .Installed
- arr(i, 4) = .IsOpen
- arr(i, 5) = .progID
- arr(i, 6) = .CLSID
- End With
- Next
- Worksheets.Add
- Range("a2").Resize(i, UBound(arr, 2)) = arr
- Range("a1").Resize(, UBound(arr, 2)) = Array("Name", "FullName", "Installed", "IsOpen", "progID", "CLSID")
- With ActiveSheet.UsedRange
- .EntireColumn.AutoFit
- .HorizontalAlignment = xlCenter
- End With
- MsgBox "加载项提取完成"
- Exit Sub
- ErrorHandler:
- MsgBox Err.Number & vbCrLf & _
- Err.Description
- Resume Next
- End Sub
复制代码
|
|