Feb 02 2023 11:50 PM
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\Devis ";B2;".xlsx'!Toto") ---> with the value of B2 is "230505"
Do you have and idea ?
Thanks for your help
Feb 03 2023 12:03 AM
Feb 03 2023 12:12 AM
Feb 03 2023 12:29 AM
Feb 03 2023 12:48 AM
Feb 03 2023 01:16 AM
Feb 03 2023 01:44 AM
Feb 03 2023 06:21 PM
Hello @BenjaminFRT,
Check this out: Referencing an unopened EXCEL file