代码如下:
Implements IDTExtensibility2
'Global object references
Public appHostApp As Word.Application
Private WithEvents cbbButton As Office.CommandBarButton
Private Sub IDTExtensibility2_OnAddInsUpdate(custom() As Variant)End SubPrivate Sub IDTExtensibility2_OnBeginShutdown(custom() As Variant)End SubPrivate Sub IDTExtensibility2_OnConnection(ByVal _
Application As Object, ByVal ConnectMode As _
AddInDesignerObjects.ext_ConnectMode, ByVal AddInInst _
As Object, custom() As Variant)' 存储启动引用
Set appHostApp = Application' 添加命令条
Set cbbButton = CreateBar()
End Sub
Private Sub IDTExtensibility2_OnDisconnection(ByVal _
RemoveMode As AddInDesignerObjects.ext_DisconnectMode, _
custom() As Variant)RemoveToolbar
' 移除要关闭的引用
Set appHostApp = Nothing
Set cbbButton = Nothing
End Sub
Public Function CreateBar() As Office.CommandBarButton
' 指定命令条
Dim cbcMyBar As Office.CommandBar
Dim btnMyButton As Office.CommandBarButtonOn Error GoTo CreateBar_ErrSet cbcMyBar = appHostApp.CommandBars.Add(Name:="属性映射Bar")' 指定命令条按钮
Set btnMyButton = cbcMyBar.Controls.Add(Type:=msoControlButton, _
Parameter:="属性映射")
With btnMyButton
.Style = msoButtonCaption
.BeginGroup = True
.Caption = "&属性映射"
.ToolTipText = "Display Hello World Message"
.Width = "24"
End With' 显示并返回命令条
cbcMyBar.Visible = True
Set CreateBar = btnMyButton
Exit FunctionCreateBar_Err:
MsgBox Err.Number & vbCrLf & Err.Description
End Function
Private Function RemoveToolbar()
appHostApp.CommandBars("属性映射Bar").Delete
End Function
Private Sub cbbButton_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)Dim WordTemps As New Word.Application
WordTemps.Run MacroName:="setdocproperties"End SubPrivate Sub IDTExtensibility2_OnStartupComplete(custom() As Variant)
End Sub 执行报错:不能运行指定的宏 请高手解答。谢谢
Implements IDTExtensibility2
'Global object references
Public appHostApp As Word.Application
Private WithEvents cbbButton As Office.CommandBarButton
Private Sub IDTExtensibility2_OnAddInsUpdate(custom() As Variant)End SubPrivate Sub IDTExtensibility2_OnBeginShutdown(custom() As Variant)End SubPrivate Sub IDTExtensibility2_OnConnection(ByVal _
Application As Object, ByVal ConnectMode As _
AddInDesignerObjects.ext_ConnectMode, ByVal AddInInst _
As Object, custom() As Variant)' 存储启动引用
Set appHostApp = Application' 添加命令条
Set cbbButton = CreateBar()
End Sub
Private Sub IDTExtensibility2_OnDisconnection(ByVal _
RemoveMode As AddInDesignerObjects.ext_DisconnectMode, _
custom() As Variant)RemoveToolbar
' 移除要关闭的引用
Set appHostApp = Nothing
Set cbbButton = Nothing
End Sub
Public Function CreateBar() As Office.CommandBarButton
' 指定命令条
Dim cbcMyBar As Office.CommandBar
Dim btnMyButton As Office.CommandBarButtonOn Error GoTo CreateBar_ErrSet cbcMyBar = appHostApp.CommandBars.Add(Name:="属性映射Bar")' 指定命令条按钮
Set btnMyButton = cbcMyBar.Controls.Add(Type:=msoControlButton, _
Parameter:="属性映射")
With btnMyButton
.Style = msoButtonCaption
.BeginGroup = True
.Caption = "&属性映射"
.ToolTipText = "Display Hello World Message"
.Width = "24"
End With' 显示并返回命令条
cbcMyBar.Visible = True
Set CreateBar = btnMyButton
Exit FunctionCreateBar_Err:
MsgBox Err.Number & vbCrLf & Err.Description
End Function
Private Function RemoveToolbar()
appHostApp.CommandBars("属性映射Bar").Delete
End Function
Private Sub cbbButton_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)Dim WordTemps As New Word.Application
WordTemps.Run MacroName:="setdocproperties"End SubPrivate Sub IDTExtensibility2_OnStartupComplete(custom() As Variant)
End Sub 执行报错:不能运行指定的宏 请高手解答。谢谢
没做完程序尽量不要进行错误处理
没做完程序尽量不要进行错误处理 能不能详细解释一下
'这个中间没有实例化WordTemps? 直接不可运行
WordTemps.Run MacroName:="setdocproperties"
Dim WordTemps As New Word.Application
WordTemps.Documents.Add App.Path + "\含有宏.dot ", False 需要加这个代码么
WordTemps.Run MacroName:="setdocproperties"
word我没写过,excel的 workbook.Add(Template) 、、 workbook.open(filename,……)