Forum Discussion
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...
try this:
=INDIRECT(CONCAT("@'W:\_Devis\Devis ";B2;".xlsx'!Toto"))
=INDIRECT(CONCAT("@'W:\_Devis\Devis ";B2;".xlsx'!Toto"))
INDIRECT is ok if the file is open, it isn't ok for me