bstiffler582

I found this thread on a search, and since it was useful to me, I'm going to bump it with some up-to-date revisions. Rockwell no longer uses RsiOPCAuto.dll - The new file is the OPC DA Automation Wrapper (2.02 at this time). The file is OPCDAAuto.dll and should be in your system32 folder if you have RSLinx installed. Your object declarations will now look like this: Public MyOPCServer As OPCAutomation.OPCServer Public WithEvents MyOPCGroup As OPCAutomation.OPCGroup Set MyOPCServer = New OPCAutomation.OPCServer etc... Where "OPCAutomation" has replaced any instance of RsiOPCAuto. I downloaded the most recent file in this thread and revised it to working condition with a ControlLogix processor. The PLC program is blank and just contains three tags, two at the Program level and one at the controller level. As a warning, this workbook is very temperamental and crashed frequently while I was testing. Now that it is reading values smoothly you can implement any kind of error checking or safety measures you'd like. I wanted to make this more publicly available as it was difficult to find Excel projects that used OPC instead of out-of-date DDE solutions I see popping up everywhere in my searches. To the last poster (07/2012): The error you were getting was difficult to debug because the VBA debug button simply takes you to the call of the function and not the actual error within. There were a few little typos and incorrect uses of the OPC objects that caused these. They are fixed in the file I have uploaded. RSLINX OPC TEST.xls