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.
Who is Participating?
criConnect With a Mentor Commented:
From a PAQ I participated:

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:

(assume stock name is in A1 cell). Now if you change name in A1 cell, you'll get what you want

Hope it helps

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.  

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

BTW: Using INDIRECT does not work here.
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.