Search code examples
excelvbacomactivexcommon-controls

ActiveX component can’t create object : PCOMM.autECLConnList

I am trying to automate the sending keystrokes to a mainframe application which is being connected using PCOMM iSeries emulator. I am not sure on what I am doing wrong here, as the same code works on a different machine. Below are the configurations,

Working Machine : Windows 10 64 bit, Office 32-Bit

Error Machine : Windows 7 64 bit, Office 64-Bit

Below is the code

On Error Resume Next

Set autECLWinObj = CreateObject("PCOMM.autECLConnList")

Set IA = CreateObject("PCOMM.autECLOIA")
Set PS = CreateObject("PCOMM.autECLPS")

PS.SetConnectionByName (Client)
IA.SetConnectionByName (Client)
autECLWinObj.SetConnectionByName (Client)

Please help, i am new to this and stuck .

P.S : Kindly don't duplicate the question as there are none specific to PCOMM.

Solution

  • Changed MS Office 64 to MS Office 32 and it worked.