Transfer data to excel

[argen78]

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

[MikeS]

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

[Greg]

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:

• http://www.hosteng.com/FAQFiles/DS%20Data.htm#FAQ0032
• http://www.hosteng.com/FAQFiles/DS%20Data.htm#FAQ0036
• http://www.hosteng.com/FAQFiles/DS%20Data.htm#FAQ0054
• http://www.hosteng.com/FAQFiles/DS%20Data.htm#FAQ0056
• http://www.hosteng.com/FAQFiles/DS%20Data.htm#FAQ0057
• http://www.hosteng.com/FAQFiles/DS%20Data.htm#FAQ0061

[argen78]

They said " if you post it...... they will reply"
Thanks guys