Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.com.add_ins,microsoft.public.office.developer.automation
|
|||
|
|||
![]()
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 ----------------------------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AddIn functions in code? | Excel Programming | |||
create custom menu with addin connect/disconnect | Excel Programming | |||
using code from an addin | Excel Programming | |||
Why won't this code connect to ODBC | Excel Programming | |||
using a function in an addin in my vba code | Excel Programming |