how i get this to work?
B4 = BMEF3
function:
=CONCATENAR("=TZMS|";B4;"!VAR")
and this its what should do:
=TZMS|BMEF3!VAR
how im supposed to do that function work?
how i get this to work?
B4 = BMEF3
function:
=CONCATENAR("=TZMS|";B4;"!VAR")
and this its what should do:
=TZMS|BMEF3!VAR
how im supposed to do that function work?
Hi, Are you trying to select a sheet by what ever name you have in B4?Originally Posted by shd
http://support.microsoft.com/kb/213933
Originally Posted by shdTry That!Please Login or Register to view this content.
Excel 2007 SP1
didn`t workOriginally Posted by WHWALDREP
yes, it`s an DDE linkOriginally Posted by davesexcel
just change the B4 cell, and get other link
What didn't work with WHWALDREP's formula?
What was in B4 and what did the function return?
Also, are we looking a spreadsheet formula or do you need it for a VB routine?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I think he saying B4 contains a link to where he wants the data to come from, other wise the formula I gave him should work.
so would it not bePlease Login or Register to view this content.
Last edited by WHWALDREP; 12-18-2007 at 10:50 PM.
B4 contains the stock paper, the name of it, like BMEF3
with the dde client opened and the =TZMS|BMEF3!VAR function on excel, this will return to the cell the value of the % of the stock...
so i was wondering in do an function that i dont have to change all stocks papers, but just one, like the =CONCATENAR("=TZMS|";B4;"!VAR") function, where in B4 cell i just change it of BMEF3 for BOVH3 and i got the % value of the other stock...
actually, your function worked, but not like supposed to be..Originally Posted by WHWALDREP
it return TZMS|BMEF3!VAR, but it has to return a FUNCTION =TZMS|BMEF3!VAR
Last edited by shd; 12-18-2007 at 10:55 PM.
is there a difference in CONCATENATE and CONCATENAR or a typo?Originally Posted by shd
no no, sorry about that...Originally Posted by WHWALDREP
my office is in portuguese... is the same function
k, must not be following you on what your after, by the meanine you can insert a function in a function like thisPlease Login or Register to view this content.
the if part its easy...Originally Posted by WHWALDREP
the =TZMS|BMEF3!VAR is a function that get from an external executable the values...
this function inside the CONCATENATE doesnt return the value what it was supposed to return, but returns the function as text...
did you get it now?
I see, not sure right off hand.... hmmmm
Are you looking for something like this?
=INDIRECT("=TZMS|"&B4&"!VAR")
This formula inserts the contents of cell B4 in the middle of that string, so it ends up executing
=TZMS|your_value!VAR
didnt work either..Originally Posted by pjoaquin
returns #REF
Hmm, are you trying to reference an external workbook? If so, that workbook needs to be open for the INDIRECT formula to work.
I'm not familiar with the first part of your =something|something_else!another_thing format.
yes it`s openOriginally Posted by pjoaquin
your formula, =INDIRETO("=TZMS|"&B4&"!VAR"), return #REF
the original formula, =TZMS|BMEF3!VAR, return #N/D (because the stock market its closed)
New Arquivo ZIP do WinRAR.zip
here is how it`s now... just the first cell ask for the executable, (tzms.exe), the other dont ask, that means that is not working properly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks