Internet PLC Forum

General => Technical support => Topic started by: can on January 08, 2018, 10:23:27 PM

Title: Excelink
Post by: can on January 08, 2018, 10:23:27 PM

Hi. Is there any way for Excel link to retrieve A$ from PLC once when relays has been changed instead of reading every few seconds?

Title: Re:Excelink
Post by: support on January 16, 2018, 07:40:30 PM

Unfortunately ExcelLink is not programmable to do what you mentioned.

You may be able to program an Excel Macro based spreadsheet to retrieve the data and the macro program can then decide which other data to pull based on the result of the first set of data it retrieved. However, you do need to write the code in Excel to execute the hostlink commands interaction with the PLC via TCP/IP (Ethernet or TLServer with USB-RS232 adapter)

The following web page is a bit old but does describe one Excel spreadsheet that we wrote before using Macro to send host-link command on the PLC and process hostlink response from the PLC:

http://www.tri-plc.com/ExcelLink/ewqtoolkit.htm