+ Reply to Thread
Results 1 to 20 of 20

Function inside Concatenate Funcion ?

  1. #1
    Registered User
    Join Date
    12-18-2007
    Posts
    22

    Function inside Concatenate Funcion ?

    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?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,237
    Quote Originally Posted by shd
    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?
    http://support.microsoft.com/kb/213933

  3. #3
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78
    Quote Originally Posted by shd
    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?
    Please Login or Register  to view this content.
    Try That!
    Excel 2007 SP1

  4. #4
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    Quote Originally Posted by WHWALDREP
    Please Login or Register  to view this content.
    Try That!
    didn`t work

  5. #5
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    Quote Originally Posted by davesexcel
    Hi, Are you trying to select a sheet by what ever name you have in B4?
    http://support.microsoft.com/kb/213933
    yes, it`s an DDE link

    just change the B4 cell, and get other link

  6. #6
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,207
    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.

  7. #7
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78
    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 be
    Please Login or Register  to view this content.
    Last edited by WHWALDREP; 12-18-2007 at 10:50 PM.

  8. #8
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    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...

  9. #9
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    Quote Originally Posted by WHWALDREP
    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 be
    Please Login or Register  to view this content.
    actually, your function worked, but not like supposed to be..

    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.

  10. #10
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78
    Quote Originally Posted by shd
    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...
    is there a difference in CONCATENATE and CONCATENAR or a typo?

  11. #11
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    Quote Originally Posted by WHWALDREP
    is there a difference in CONCATENATE and CONCATENAR or a typo?
    no no, sorry about that...
    my office is in portuguese... is the same function

  12. #12

  13. #13
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78
    k, must not be following you on what your after, by the meanine you can insert a function in a function like this
    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    Quote Originally Posted by WHWALDREP
    k, must not be following you on what your after, by the meanine you can insert a function in a function like this
    Please Login or Register  to view this content.
    the if part its easy...



    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?

  15. #15
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78
    I see, not sure right off hand.... hmmmm

  16. #16
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881
    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

  17. #17
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    Quote Originally Posted by pjoaquin
    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..

    returns #REF

  18. #18
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881
    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.

  19. #19
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    Quote Originally Posted by pjoaquin
    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 open

    your formula, =INDIRETO("=TZMS|"&B4&"!VAR"), return #REF
    the original formula, =TZMS|BMEF3!VAR, return #N/D (because the stock market its closed)

  20. #20
    Registered User
    Join Date
    12-18-2007
    Posts
    22
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1