Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DDE linking with variable from named cell!
I have tried and tried to create a DDE link to an application which retrieves
stock prices etc. The basic goal is to have the dde link in a cell, but the variable (ie stock name) is read from another cell on the worksheet! is this achievable in Excel. I can do this by creating simple macro that extracts the variable from a cell and then paste the formula to another cell, but I am trying to do this without using VBA. Any help greatly appreciated!! Ben Joiner |
#2
|
|||
|
|||
Ben
I think the macro is the only to create the DDE link using a variable value from a cell. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions | |||
Named Cell Ranges | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions |