Forum Discussion
BenjaminFRT
Feb 03, 2023Copper Contributor
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...
Rodrigo_
Feb 03, 2023Steel Contributor
try this:
=INDIRECT(CONCAT("@'W:\_Devis\Devis ";B2;".xlsx'!Toto"))
=INDIRECT(CONCAT("@'W:\_Devis\Devis ";B2;".xlsx'!Toto"))
- BenjaminFRTFeb 03, 2023Copper ContributorINDIRECT is ok if the file is open, it isn't ok for me
- BenjaminFRTFeb 03, 2023Copper ContributorThanks but,
=INDIRECT(CONCAT("[";B2;".xlsx]Feuil1!$O$6")) is ok
but with th right link it's not ok ? an idea ?- BenjaminFRTFeb 03, 2023Copper Contributor$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
- BenjaminFRTFeb 03, 2023Copper Contributor#REF.. but no problem with the destination..
- BenjaminFRTFeb 03, 2023Copper ContributorI have try without concat by using &
=INDIRECT("@'W:\_Devis\Devis "&B2&".xlsx'!Toto")
same result an over idea ?