Excel Error: 'ActiveX component can't create object' after KiteNet DLL update.

HowUTrade

Hello KiteNet Users,

You may receive one or all of the below mentioned errors in Excel/VBA after updating KiteNet.dll

'ActiveX component can't create object'
'Automation Server Can't Create Object'
'Can't find project or library'

Note: The below solution is applicable only if you get the above errors after updating KiteNet.dll

Background:
When we update a new version of COM DLL (like KiteNet) in the system, the Excel/VBA will still look for the older version with which the VBA Project is created initially. Since the old DLL is replaced with the new DLL, Excel/VBA will throw the above errors as it is unable to find the old DLL.

Solution:
1. Go to Visual Basic editor : Menu --> Developer Tab --> Select 'Visual Basic' or simply Press Alt + F11
2. Once the Visual Basic editor is opened, select the 'KiteXL' module from the project explorer. (If project explorer is not visible then : Menu --> View --> Select 'Project Explorer' or simply press Ctrl + R)
3. Just select all the code in the right side by pressing Ctrl + A and cut all the code by pressing Ctrl + X and again paste all the code by pressing Ctrl + V and save.
4. Now compile VBA Project by Menu --> Debug --> Select 'Compile VBA Project'
5. That's it, now you can use KiteXL.

Here is how it worked, when we cut and paste the code in VBA, we (re)created the VBA Project which uses the new version of the COM DLL.