Link to file in subdirectory
Hi Joel, and thank you for your awnser !
Its a good begining, but what I have to do is a bit more difficult.
Excuse me for my misexplanation.
My files are not all in the directory 'MyDir'.
There are a lot of subdirectories, with various names convention.
I need a function that recursively find the file location with a filter
function.
Exemple : cell A1 contains "A-ZER-TY"
the file to link to is in
\MyDir\projetct\projectblablabla\AZERTY.APJ
I need to put a link in B1 to this file
And so from A1 to Ax.
But I like to thank you a lot for your awnser.
It's a nice begining for me and I will try to work on it to improve your
function.
If anyone have others suggestions, you are welcome !
Best regards,
Matthieu
|