Excel-Reuters link

I have a reuters Ric code in excel eg. =REUTER|CANTOR!'ARGFRB,6'
I want to know how to remove 'ARGFRB' from the formula by referencing it in another cell.
I've tried concatenating but this doesn't help.
QWERTY99Asked:
Who is Participating?
 
criConnect With a Mentor Commented:
From a PAQ I participated:

XXXX
From: vboukhar Date: Monday, September 06 1999 - 06:23AM PDT  

OK, look at another suggestion:
Add Module to your VBAproject (Alt-F11) of your workbook and add code below (to create user-defined
function for on-sheet usage):

Public Function DoEval(a As String)
DoEval = ActiveSheet.Evaluate(a)
End Function

Now at your sheet you can place formula like that, where create desirable string with CONCATENATE function:

"=DoEval(CONCATENATE("STOCK|NYSE!",A1))"
(assume stock name is in A1 cell). Now if you change name in A1 cell, you'll get what you want

Hope it helps
XXXX

Remark: Depending of how many manual inputs your spreadsheet has, the calculation probably should be
set at manual or triggered by some macro, otherwise you will have multiple updating.  

0
 
criCommented:
Another alternative is to _write_ the formula into the cell using VBA.

BTW: Using INDIRECT does not work here.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.