|
Option Explicit
Public app As Excel.Application
'Private Sub IDTExtensibility2_OnConnection(ByVal Application As Object, ByVal ConnectMode As AddInDesignerObjects.ext_ConnectMode, ByVal AddInInst As Object, custom() As Variant)
'Set app = Application
'MsgBox 1
'End Sub
'
'
'
'Private Sub IDTExtensibility2_OnDisconnection(ByVal RemoveMode As AddInDesignerObjects.ext_DisconnectMode, custom() As Variant)
'
'Set app = Nothing
'MsgBox 2
'End Sub
Private Sub AddinInstance_OnConnection(ByVal Application As Object, ByVal ConnectMode As AddInDesignerObjects.ext_ConnectMode, ByVal AddInInst As Object, custom() As Variant)
Set app = Application
MsgBox 1
End Sub
Private Sub AddinInstance_OnDisconnection(ByVal RemoveMode As AddInDesignerObjects.ext_DisconnectMode, custom() As Variant)
Set app = Nothing
MsgBox 2
End Sub
Function Str(ByVal ran As Range) As String
Dim r As Range
Set ran = Range("b1:b10")
For Each r In ran
Str = Str & r
Next r
End Function
问题1:如何修改程序使得当这个外接程序封装成dll文件后,只要excel2003加载了这个dll文件后就能直接使用自定义函数str.
问题2:如果在这个外接程序中将初始化行为设置为load on demand并生成dll文件后,那么在excel2003中若要使用该加载宏该怎么加载?
若选择load at next startup only 与none分别代表什么,在excel2003中需要用时又该怎么加载?
问题3:
IDTExtensibility2_OnConnection事件的作用是什么?该怎么用?
|
|