PLC to Excel How can I Start a Macro From PLC

[RayfromIntech]

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

 

[Binary]

Ray, I suggest you try posting this questions in the PLC forum on this site (forum791) and perhaps consider posting at

http://www.plcs.net

as well.

 

[Jezz]

Try this

ActiveWorkbook.SetLinkOnData &quot;<DDE link Info e.g \\PCName\Aplication|Topic!'N7:1/0'&quot;, &quot;MyMacro&quot;

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