本文介绍了Excel Addins的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好
我的excels中有一些插件,我需要一个宏代码来检查这些插件是否已启用或已禁用。\\ n \\ n我没有找到任何选项来检查这个。
I have some addin in my excels and i need a macro code which check whether these addin as enabled or disabled. I didn't find any options which do check this.
问候
Nishant Kumar
Nishant Kumar
推荐答案
你可以尝试这段代码:
Sub check_addins()
With Worksheets("sheet2")
.Rows(1).Font.Bold = True
.Range("a1:d1").Value = _
Array("Name", "Full Name", "Title", "Installed")
For i = 1 To AddIns.Count
.Cells(i + 1, 1) = AddIns(i).Name
.Cells(i + 1, 2) = AddIns(i).FullName
.Cells(i + 1, 3) = AddIns(i).Title
.Cells(i + 1, 4) = AddIns(i).Installed
Next
.Range("a1").CurrentRegion.Columns.AutoFit
End With
End Sub
它适用于Excel 2005和2007.
it works with Excel 2005 and 2007.
干杯,
Franck
这篇关于Excel Addins的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!