Host Engineering Forum

General Category => DirectSOFT => Topic started by: argen78 on September 17, 2009, 02:33:51 PM

Title: Transfer data to excel
Post by: argen78 on September 17, 2009, 02:33:51 PM
Ok without getting a bit nutty here. Point me in the right direction. I am looking to transfer 8 diffrent "V" memory locations onto a spread sheet, like excel.Same "V" memory must get transfered again to the next set of
cell's. I know there is VB involved but what other type of software from AD would be helpfull and simple to do such a task. If there is anybody who has done this without VB please let me know.

Cheers
Title: Re: Transfer data to excel
Post by: MikeS on September 18, 2009, 10:31:13 AM
the DSData Server, which is a DDE/OPC server, can do that. you'll have to ask for it by name because i don't think it's not on the web site

the other option is KEPDirect, an OPC server can do it as well
Title: Re: Transfer data to excel
Post by: Greg on September 18, 2009, 10:36:38 AM
argen78,

To do this requires a program like DSData or KEPDirect. These programs basically provide the interface between Windows applications (like Excel) and the PLC by providing the communication drivers necessary to talk to the PLC's V-memory, and the formatting of the data in order for Excel to use it.

For various examples using VisualBASIC in Excel to do what you are wanting to do, see the following FAQs:
Title: Re: Transfer data to excel
Post by: argen78 on September 18, 2009, 03:12:16 PM
They said " if you post it...... they will reply"
Thanks guys ;)