View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How to pick up file name in the cell

=CELL("filename",A1) will even supply you with the path as well.
--
Gary's Student


"Vijay Kotian" wrote:

I would like to use the name of the file in the cell. How can i do that?