Connect a COM AddIn from VBA Code
 

Hi,
I need to connect a registered COM Add In from workbook Open event.
But every code I write, like these below, raise error 1004.
What is wrong ?
TIA,
Maurizio Bellantone

-----------------------------------------------------
Private Sub Workbook_Open()
Dim x As Integer

Application.COMAddIns("MyAddIn.Connect").Connect = True

End Sub
-----------------------------------------------------
Private Sub Workbook_Open()
Dim x As Integer

x = Excel.Application.COMAddIns.Count

End Sub
-----------------------------------------------------

Connect a COM AddIn from VBA Code
 

Resolved.
It didn't work on development pc, where dll addin is not registered. On test
pc work without problems.
Bye.

"Maurizio BELLANTONE" <bellantoneCHIOCCIOLAlibero.it ha scritto nel
messaggio ...
Hi,
I need to connect a registered COM Add In from workbook Open event.
But every code I write, like these below, raise error 1004.
What is wrong ?
TIA,
Maurizio Bellantone

-----------------------------------------------------
Private Sub Workbook_Open()
Dim x As Integer

Application.COMAddIns("MyAddIn.Connect").Connect = True

End Sub
-----------------------------------------------------
Private Sub Workbook_Open()
Dim x As Integer

x = Excel.Application.COMAddIns.Count

End Sub
-----------------------------------------------------