PLC to Excel How can I Start a Macro From PLC
PLC to Excel How can I Start a Macro From PLC
(OP)
I am using Excel 2000 with a SLC503 Allen Bradley.
How can I for example
If N7:1/0 = 1 Then run a macro.
Is there some way of monitoring the PLC information and immediatly reacting to it and this is the key WITHOUT LOOPING A MACRO TO SCAN DATA.
Note I am familliar with how to communicate just want to start a macro base on data change.
Appreciate yours solutions and or comments
Best regards
Raymond
How can I for example
If N7:1/0 = 1 Then run a macro.
Is there some way of monitoring the PLC information and immediatly reacting to it and this is the key WITHOUT LOOPING A MACRO TO SCAN DATA.
Note I am familliar with how to communicate just want to start a macro base on data change.
Appreciate yours solutions and or comments
Best regards
Raymond





RE: PLC to Excel How can I Start a Macro From PLC
RE: PLC to Excel How can I Start a Macro From PLC
ActiveWorkbook.SetLinkOnData "<DDE link Info e.g \\PCName\Aplication|Topic!'N7:1/0'", "MyMacro"
I've used this a lot to monitor change in values you have to check as it runs macro when value changes not just when it equals 1.
Jezz