PC Review


Reply
Thread Tools Rate Thread

Add reference to DDE Link formula

 
 
=?Utf-8?B?eGxjaGFybGll?=
Guest
Posts: n/a
 
      11th Jul 2006
I have a number of formulas used to pull data from another system into Excel.
Three example formulas are:

=Systemx|Bid!GOOG
=Systemx|Ask!GOOG
=Systemx|Last!GOOG

Systemx is the other system. After the | is the argument specifying what
information to pull. And you might recognize the argument after the ! as a
stock ticker. I want to replace the ticker with a cell reference so that I
can change the value in the cell from GOOG to YHOO and the formulas will
recalculate with the data from YHOO instead of GOOG. If I try to just
replace the ticker with the cell reference, the resulting formula,
=Systemx|Ask!'A13', doesn't work.

I'm think there should be a way to construct the formula as a string (e.g.
="Systemx|Ask!" & A13) and then force Excel to evaluate the string as a
function. As is, Excel will construct the string and then display it as text
in the cell rather than evaluate it as a function. I know I can do a
work-around using VBA, but I'm hoping there is a solution without VBA,
perhaps a built in function.

Is anyone familiar with DDE links or otherwise know a way to fix my problem?
Thanks for your help!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to use date in file name link reference DFruge Microsoft Excel Worksheet Functions 2 23rd May 2009 02:12 AM
Using a cell reference as part of a link in a formula =?Utf-8?B?TWlzc3k=?= Microsoft Frontpage 2 2nd Feb 2006 09:08 PM
Q: Can a formula reference a cell to get the file name to link to for data? mgarcia Microsoft Excel Misc 3 18th Jan 2006 02:56 PM
De-link a cell reference in a formula. Hari Prasadh Microsoft Excel Programming 2 3rd Feb 2005 12:34 PM
How can I format a cell with a link formula so an empty reference. =?Utf-8?B?U3RldmVH?= Microsoft Excel Misc 0 16th Sep 2004 05:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:21 PM.