unsunghippie
Member
It's been a while since I have had to interface Excel with a AB PLC. Typically what has been done in the past is to use RSLinx pro as OPC/DDE interface between Excel and Micrologix. I now hear RSLinx pro is being retired, in favor of Factorytalk Gateway. I also see on the Linx comparison chart that Gateway does not support DDE. I do not have a copy of Gateway here to play with. Which leads me to:
- How do I OPC with Excel? I see there are may third party OPC vendors that make this easy. Do I have to use third party, or activeX, or can I script in VBA?
I'm having a hard time researching this and getting the info I need. Any help is appreciated.
- How do I OPC with Excel? I see there are may third party OPC vendors that make this easy. Do I have to use third party, or activeX, or can I script in VBA?
I'm having a hard time researching this and getting the info I need. Any help is appreciated.