Forum Discussion

BenjaminFRT's avatar
BenjaminFRT
Copper Contributor
Feb 03, 2023

create function value link

Hi, Today  I use this type of link, and it's good =@'W:\_Devis\Devis 230505.xlsx'!Toto  ----> Toto is a predef cell but I want to generate the link like something like this =CONCAT("@'W:\_Devis\D...
Excel
Formulas and Functions
Rodrigo_'s avatar
Rodrigo_
Steel Contributor
Feb 03, 2023
try this:
=INDIRECT(CONCAT("@'W:\_Devis\Devis ";B2;".xlsx'!Toto"))
  • BenjaminFRT's avatar
    BenjaminFRT
    Copper Contributor
    Feb 03, 2023
    #REF.. but no problem with the destination..
    • BenjaminFRT's avatar
      BenjaminFRT
      Copper Contributor
      Feb 03, 2023
      I have try without concat by using &
      =INDIRECT("@'W:\_Devis\Devis "&B2&".xlsx'!Toto")
      same result an over idea ?
  • BenjaminFRT's avatar
    BenjaminFRT
    Copper Contributor
    Feb 03, 2023
    Thanks but,
    =INDIRECT(CONCAT("[";B2;".xlsx]Feuil1!$O$6")) is ok
    but with th right link it's not ok ? an idea ?
    • BenjaminFRT's avatar
      BenjaminFRT
      Copper Contributor
      Feb 03, 2023
      $O$6 or Toto is ok
      path with or with space same problem, idem by using operator & or concat
      same directory with file open with "[" and "]" ok, but when you close the file.. error
  • BenjaminFRT's avatar
    BenjaminFRT
    Copper Contributor
    Feb 03, 2023
    INDIRECT is ok if the file is open, it isn't ok for me

Share