| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to build DDE link with text from another cell
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to build a formula from a string of text | Excel Worksheet Functions | |||
| build external ref in formula from text? | Excel Discussion (Misc queries) | |||
| Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
| Use Cell Content to Build Link | Excel Worksheet Functions | |||
| How do I build a free text note from a template? | Excel Worksheet Functions | |||
Linear Mode
