Archive of Mr Excel Message Board


Back to Links in Excel archive index
Back to archive home

Can anyone help with DDE linking?

Posted by Myles on August 06, 2001 12:20 PM
Let me see if I can clarify this:
Simply typing
=abDDE|Bar!'ART;LEVEL'
into a cell results in an active dynamic data exchange feed from the program "abDDE" on the topic "Bar" providing the "LEVEL" on "ART" This formula is similar to the example given in Excel Help under the topic "About using a formula to link data from programs not on your computer"

My problem is that, as far as I can tell, this formula requires one to manually enter the symbol (in this case ART) for the feed to work. So simple concatenation doesn't work unfortunately (thanks for the attempt thought Jerid).

What I'm looking for I think is a work around that will generate a working DDE formula as above for a Symbol several columns to the left.

I am attempting to automate a worksheet which tracks data on approximately 40-50 such symbols at a time. I would like to make it as idiot-proof as possible so that anyone in my office can sitdown and type a series of symbols in a given column and get a live feed for each of these symbols without having to type in or worry about the DDE formula.

Whew... It's a lot less complicated than it sounds, and I have a feeling there's a simple solution.

Does anybody have familiarity with these DDE formulas?

Thanks for your help,
-Myles


Re: Can anyone help with DDE linking?

Posted by Jerid on August 07, 2001 5:50 AM

Myles

Have you thought about writing a Macro to do this? You could have the users type what they are looking for into predefined cells and then click a button that would run your macro.
This might get you around your issue.

Sample code from Microsoft Help.

Sub test()
channelNumber = Application.DDEInitiate(app:="WinWord", topic:="System")

returnList = Application.DDERequest(channelNumber, "Topics")

For i = LBound(returnList) To UBound(returnList)
Worksheets("Sheet1").Cells(i, 1).Formula = returnList(i)
Next i

Application.DDETerminate channelNumber
End Sub

I know this isn't a lot of help, but I don't have that abDDE application, and can't see your problem first hand.

Sorry.

Jerid


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.