Hello,
I want to insert a file name in a cell when i open a file. This is what I am currently using:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5)
The -5 at the end removes the elm extension from the displayed name
This works when I open the file, directly from Finder. However, as the file is linked to a master file when I open this file using the link in the master file, I don't get the file name, It shows part of the directory structure.
Any help please
I want to insert a file name in a cell when i open a file. This is what I am currently using:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5)
The -5 at the end removes the elm extension from the displayed name
This works when I open the file, directly from Finder. However, as the file is linked to a master file when I open this file using the link in the master file, I don't get the file name, It shows part of the directory structure.
Any help please