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...
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 ?
BenjaminFRT
Feb 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
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