View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Insert file name in cells

=CELL("filename",A1)

File must be saved before it will work......

Vaya con Dios,
Chuck, CABGx3


"Mohan De Silva" wrote in message
...
I need to insert the file name in a cell of the work page (with a funtion)
and be able to change automatically if & when the file name id edited. I

Use
this on a cover page .