Data exchange between a DDE prog and excel

L

Leo Butler

Howdy

I am running a data capture program using a dde server excel and a plc .
when i save the program data stores in the plc to excel using the dde , i
can save them into a folder. When i want to reupload the saved program from
my workbook to the plc the existing program that is held in the plc memory
over writes the saved program in my work book.

When i open the file in the workbook excel displays the following warning

"This workbook contains links to other data sources"
If you update the links, excel will attempt to retrieve the latest
information.
update don't update.


What i want to do is not update the saved data in the workbook but update
the tags in the dde server from my work book.

Tag- =DDEIprogram name!Tag_#

Subpoke

Channel=application.DDEInitate(DDE_ "program name")

setvalue=Worksheets (sheet1) Cells (1,2)
Application. DDEpoke Channel,"Tag_1"value

hope some one can show me the error of my ways.
Leo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top