Dear experts,
We are having problems with the Click to Call Addin in MS Excel.
We have developed an Excel application, that has a COM referenced that is a connection to our SAP System and when we deployed Click To Call in all machines we faced with this error message (please see attachment 1):
Run-time error ¿-2147417848 (80010108)¿:
Automation error
The object invoked has disconnected from its clients.
Since we realized about this issue, we started to do some workarounds. If Click to Call is disabled or uninstalled from the computer, our application runs properly. So we did some tests and we find out that if there is a COM registered to the VBA project in Excel, doesn'7 matter the COM complexity, both the COM and Click to Call can't work.
We have created a simple XLS file which has referenced a simple COM DLL with that only has a function that returns a string. There isn¿t another process in this DLL, no connection to SAP neither another type of process.
Into the XLS file, there is a macro that sort a column using this simple code:
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("G2"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
-------------------------------------------------------------------------------------
Test 1-
XLS file with our simple COM referenced
Click to call Addin enabled
When we try to run the VBA Macro, we get this error message:
Run-time error ¿-2147417848 (80010108)¿:
Automation error
The object invoked has disconnected from its clients.
-------------------------------------------------------------------------------------
Test 2-
XLS file with our simple COM referenced
Click to call Addin DISABLED
When we try to run the VBA Macro and we don´t get any unexpected result.
--------------------------------------------------------------------------------------
Test 3-
XLS file with our simple COM NOT referenced
Click to call Addin ENABLED
When we try to run the VBA Macro and we don´t get any unexpected result.
-------------------------------------------------------------------------------------
We tried those scenarios with Office 2003 and Office 2007 as well.
It seems that any COM as simple as it can be registered on the XLS file and the Click to Call Addin can¿t work together.
Attached to this message you will find a ZIP file that contains:
· XLS file
· DLL COM (a BAT to register an unregister it)
Be aware that after registering the DLL COM you have to manually reference it into the XLS file.
The XLS file and the COM DLL are in the attachment testCCTC.zip
Also attached to this form is the complete solution of our simple COM file developed in VB.NET 2003 in attachment TestCOM.zip
Could you please give us a help regarding this issue???
We have already opened a ticket with Cisco Support: SR 615625005, the recomendation was to open the case here in CDN.
Kindest regards,
Pablo Gómez
