Thread: get filename and filepath
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
  
Posts: 493
Default get filename and filepath
One way:

=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))


In article ,
"Robert Ehrlich" wrote:

How can I get my own filename and filepath?
Is there any function which provides this?
Reply With QuoteReply With Quote