LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.com.add_ins,microsoft.public.office.developer.automation
external usenet poster
 
Posts: 11
Default 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
-----------------------------------------------------


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AddIn functions in code? Rbp9ad[_2_] Excel Programming 3 October 14th 05 02:54 PM
create custom menu with addin connect/disconnect dayanand108[_4_] Excel Programming 1 September 10th 05 01:27 PM
using code from an addin alfaista[_2_] Excel Programming 4 April 27th 04 03:36 PM
Why won't this code connect to ODBC sjones Excel Programming 2 April 14th 04 11:42 AM
using a function in an addin in my vba code archangel Excel Programming 2 September 6th 03 08:09 AM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"