I'm tryin to get used with the DDE commands. Lookin' at the VB5 guide I've founded the example for opening a connection with Excel and returning results of a formula in a textbox.
The problem that makes me not going on is :
- after opening the Excel application the VB script tries to link textbox with "R1C1" in this way:
Text1.LinkTopic = "Excel|Sheet1"
Text1.LinkItem = "R1C1"
Text1.LinkMode = vbLinkManual
at the third line my program crash saying that no application has answered at the DDE call, what can I do. I've tried to change the linkmode but nothing's happened.
