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"))
BenjaminFRT
Feb 03, 2023Copper Contributor
Thanks but,
=INDIRECT(CONCAT("[";B2;".xlsx]Feuil1!$O$6")) is ok
but with th right link it's not ok ? an idea ?
=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