Excel DDE Embedded reference
Hi Folks
I have the following DDE link in a cell in a spreadsheet:
=RSLINX|TOPIC_NAME!TAG_NAM
This works correctly :-)
Is it possible to get the topic and tag names from another cell ?
Something like:
=RSLINX| & Sheet1.Range("A1") & "!" & Sheet1.Range("A2")
Regards Simon
I have the following DDE link in a cell in a spreadsheet:
=RSLINX|TOPIC_NAME!TAG_NAM
This works correctly :-)
Is it possible to get the topic and tag names from another cell ?
Something like:
=RSLINX| & Sheet1.Range("A1") & "!" & Sheet1.Range("A2")
Regards Simon
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I have found a method of doing it that works for my application.
By putting the string creation into a sub and running it at startup it works correctly.
Sub MakeDDEFormulas()
Sheet2.Cells(2, 3).Formula = "=RSLINX|" & Sheet1.Cells(2, 2) & "!" & Sheet1.Cells(2, 1) & ".I2.IP001"
End Sub
The important difference about embedding the code into a cell as opposed to running a VBA function is that once the DDE is embedded into the cell it becomes an active link and updates automatically when the values in the source change.
For my application I am not continually changing the tag name in the spreadsheet but using a separate workbook for each instance that I need to read data from, this now allows me to enter the Tag and Topic values only once for each worksheet.
By putting the string creation into a sub and running it at startup it works correctly.
Sub MakeDDEFormulas()
Sheet2.Cells(2, 3).Formula = "=RSLINX|" & Sheet1.Cells(2, 2) & "!" & Sheet1.Cells(2, 1) & ".I2.IP001"
End Sub
The important difference about embedding the code into a cell as opposed to running a VBA function is that once the DDE is embedded into the cell it becomes an active link and updates automatically when the values in the source change.
For my application I am not continually changing the tag name in the spreadsheet but using a separate workbook for each instance that I need to read data from, this now allows me to enter the Tag and Topic values only once for each worksheet.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Accept: Simon (https:#a42399071)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
MacroShadow
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Accept: Simon (https:#a42399071)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
MacroShadow
Experts-Exchange Cleanup Volunteer
Premium Content
You need an Expert Office subscription to comment.Start Free Trial