Author Topic: Data Sheet  (Read 10947 times)

philipjoseph

  • Jr. Member
  • Posts: 57
    • View Profile
Data Sheet
« on: June 19, 2002, 09:23:54 AM »
I need to register a variable data (a$) at the excel Sheet1 using ExcelLink, but I need that the data will be registed to the next row only when it change.
Ej:
      Door
      Table
      Web

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

support

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3174
    • View Profile
    • Internet Programmable PLCs
Re: Data Sheet
« Reply #1 on: June 19, 2002, 12:32:13 PM »
ExcelLink only capture the data and put into the Excel cells based on the defined configuration. It does not check whether the data has been changed and then change it to another cell.

You may be able to do that by writing an ExcelMacro on another worksheet to contantsly monitor the captured string at a static location and when there is changes, record it at another cell. This is beyond the scope of the TRi-ExcelLink software.
« Last Edit: December 31, 1969, 04:00:00 PM by 1076562000 »
Email: support@triplc.com
Tel: 1-877-TRI-PLCS