how to find where is the current file saved

  • Thread starter Thread starter Holly
  • Start date Start date
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
 
It's a good idea to use:
=CELL("Filename",A1)
instead of
=CELL("Filename")

A1 can be any cell in the worksheet. I use the cell containing the formula.

Without that reference, then that formula will return the information from the
activeworkbook/worksheet when excel recalculated.



Mike said:
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 said:
Is there an easy way to find out where is the current openning file saved?
Click to expand...
Click to expand...
 
Back
Top