volatile file name

[Rajeev]

How do I make a formula for inserting the file name into a cell ie
whenever i change the file name i need the cell updated.

Thanx.

 

[Orlando Magalhães Filho]

Hi Rajeev,
Try this formula:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)


HTH

 

[Shah Shailesh]

Hi,

Use this formula posted by Rob Bovery.

=MID(CELL("FileName",$A$1),FIND("]",CELL("FileName",$A$1))
+1,999)

Works on a saved workbook.For unsaved workbook you may
have to write UDF. See

http://members.lycos.co.uk/ssweb/
Regards,
Shah Shailesh