My application is to connect to an Allen Bradley CompactLogic PLC from an Excel Spreadsheet using the Rockwell FactoryTalk OPC server.
I have installed an OPC automation wrapper in order to provide the OPC interface. However, when I try to use the OPC code in the Excel VBA I get a Microsoft Visual Basic Run-time error “429” ActiveX component can’t create object.
Does anyone have any ideas on why I am getting this error? I believe I have registered the OPC wrapper .dll but maybe I haven’t fully.
Thank you for any help.
I have installed an OPC automation wrapper in order to provide the OPC interface. However, when I try to use the OPC code in the Excel VBA I get a Microsoft Visual Basic Run-time error “429” ActiveX component can’t create object.
Does anyone have any ideas on why I am getting this error? I believe I have registered the OPC wrapper .dll but maybe I haven’t fully.
Thank you for any help.