I have a simulation software for industrial PLC use called Pics Pro. This software has a driver that's a DDE client. I'm trying to establish a connection between this software's DDE driver and excel. It asks for "Server Name" and "Topic Name". By following the help it gives me directions to write "excel" in the Server Name field and "book1" in the Topic Name field. But the connection doesn't work anyway. I've tried different method by copying the cell and pasting it in another excel document as a link, and by doing this I managed to get this information: "=Excel.Sheet.8|'C:\Documents and Settings\Administrator\Desktop\test.xls'!'!Blad1!R1C1'". I've also unchecked "ignore other applications to connect to excel" under "General" in "Properties".

I hope u can help me.