Author Topic: VB Code for Excel while using Excel Link  (Read 12207 times)

Bill Sullivan

  • Guest
VB Code for Excel while using Excel Link
« on: September 30, 2003, 03:53:28 PM »
Trying to use VB --"Change Event" ie Worksheet_(ByVal target_etc etc

to look for incomming data sent by PLC to spread sheet via excel link.
---
the change event works correctly in the spreadsheet except when activated by Excell link. When this happens no data comes into the spread sheet from the PLC. If I disable the Macro then the excell link works ok but ,the macro doesnot.

Any Ideas

Bill
« Last Edit: December 31, 1969, 04:00:00 PM by 1076562000 »