K
kt
We have an Excel addin that when loading Excel the
IDTExtensibility2_OnConnection loads fine. The function is below. However,
when we access another function from this DLL direct from another non Excel
application the function does not load the routine correctly. During the
process we first check if Excel is open and grab that object and if it is not
we create a new Excel instance. How do we then trigger the use of the
function below with that particular instance of Excel. What are the options
available for each variable in the function below and how do we ensure that
all other procedures connected with this procedure are loaded as well.
Private Sub IDTExtensibility2_OnConnection(ByVal Application As Object,
ByVal ConnectMode As AddInDesignerObjects.ext_ConnectMode, _
ByVal AddInInst As Object, custom() As Variant)
end sub
Thanks in advance.
IDTExtensibility2_OnConnection loads fine. The function is below. However,
when we access another function from this DLL direct from another non Excel
application the function does not load the routine correctly. During the
process we first check if Excel is open and grab that object and if it is not
we create a new Excel instance. How do we then trigger the use of the
function below with that particular instance of Excel. What are the options
available for each variable in the function below and how do we ensure that
all other procedures connected with this procedure are loaded as well.
Private Sub IDTExtensibility2_OnConnection(ByVal Application As Object,
ByVal ConnectMode As AddInDesignerObjects.ext_ConnectMode, _
ByVal AddInInst As Object, custom() As Variant)
end sub
Thanks in advance.