Author Topic: Control Logics 5000 - DDE/OPC to Excel (Live Data)  (Read 20503 times)

hileta

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Control Logics 5000 - DDE/OPC to Excel (Live Data)
« Reply #15 on: March 04, 2016, 12:42:01 AM »
Archie,

That is a pretty slick program. I don't think I can convince them to use it though. Is it possible to read/write to the PLC using only Excel with a macro?

Archie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5262
    • View Profile
    • AdvancedHMI
Re: Control Logics 5000 - DDE/OPC to Excel (Live Data)
« Reply #16 on: March 04, 2016, 02:12:39 AM »
Is it possible to read/write to the PLC using only Excel with a macro?
This is an area that I have not done any work with, but it may be possible using VSTO and adding an Excel Add In project to the AdvancedHMI solution:

https://www.visualstudio.com/en-us/features/office-tools-vs.aspx