I am getting data from an Allen Bradley PLC via DDE/OPC and putting it in an Excel Spread Sheet. This is a Batch report and I want to automatically print the spread sheet at the end of the batch. I want to use a value from the PLC as the trigger. I am using this code.
If Target.Address = ("$A$1") Then ActiveSheet.Printout.
This only works if I manually enter a value into that Cell. Any Suggestions?
If Target.Address = ("$A$1") Then ActiveSheet.Printout.
This only works if I manually enter a value into that Cell. Any Suggestions?
