Thread: how to find where is the current file saved
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how to find where is the current file saved
Holly,

Try this in a cell:-

Simplest and give savepath, workbook name and worksheet
=CELL("Filename")

A bit longer but information is limited to savepath
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1)) - 2)

Mike



"Holly" wrote:

Is there an easy way to find out where is the current openning file saved?
Reply With QuoteReply With Quote