View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elisabeth D Elisabeth D is offline
external usenet poster
 
Posts: 18
Default file name and path in worksheet

Enter this formula in the cell where you want the path and filename to appear:

=CELL("filename",A1)

Note: This formula will not produce a result until you save the file.

Elisabeth

"april" wrote:

is there a way to insert the file name and path in a worksheet - i'm not
talking about the footer in the print setup. i am looking for something like
the NOW function.

thanks
--
aprilshowers