We help IT Professionals succeed at work.

Excel DDE Embedded reference

345 Views
Last Modified: 2018-05-29
Hi Folks
I have the following DDE link in a cell in a spreadsheet:

=RSLINX|TOPIC_NAME!TAG_NAME

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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
Hi,
pls try
=INDIRECT("=RSLINX|"&A1&"!"&A2)

Open in new window

Regards
SimonEngineer

Author

Commented:
Unfortunately this is not working for me. Here is the code that does not work:
Capture-1.PNG
SimonEngineer

Author

Commented:
This is the code that does work:
Capture-2.PNG
Engineer
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions