how to build DDE link with text from another cell

Bruneski

Guest

Posts: n/a

27th Jun 2008

Using a DDE link in Excel is pretty simple. In my case, I use links like
=gol|cot!IBOV.ult
to recover data from a provider named GOL.
How can I obtain the same result when I need to build the link based on the
text content of a given cell? For example, assume cell A1 contains the text
IBOV. I know I can build the string
gol|cot!IBOV.ult
by using the formula
"gol|cot!"&A1&".ult"
But, when I try to use the INDIRECT function with this formula as argument,
it doesn't work! The result is a #REF.
How can I do it?
Thanks in advance.

« What percentage of heart rate | Formula »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Want to link a cell of numbers with a cell of text & can sort	Holly	Microsoft Excel Misc	1	25th Mar 2010 11:29 PM
Cell only shows link in text, not contents of reference cell	=?Utf-8?B?SmF5IE1hYw==?=	Microsoft Excel New Users	4	23rd Aug 2005 08:36 PM
Using text in cells to build a link to within another file	=?Utf-8?B?Sm9u?=	Microsoft Excel Misc	2	2nd Aug 2005 09:24 PM
Use Cell Content to Build Link	flattire00101	Microsoft Excel Worksheet Functions	1	17th Jun 2005 05:40 PM
How do I link text in a Word document to a text cell in Excel so .	=?Utf-8?B?SmVpZ2hMRw==?=	Microsoft Word Document Management	1	10th Nov 2004 09:45 PM