path function?

simp · May 16th, 2002, 07:35 AM

does anyone know if there is a function that will display the path to the workbook you are using in a cell? I'm using excel 97. Thank you.

Simp

sann0638 · May 16th, 2002, 08:14 AM

hi simp,
try =CELL("filename",A1), where A1 is any cell in the book. this will give you the path, name of book and name of sheet, which you can crop using the LEFT and RIGHT functions.

rgds
mike

Chris Davison · May 16th, 2002, 11:18 AM

or =INFO("directory") will just give you the path

(no filename or sheetname)

I seem to remember it may give you problems with network drive mappings, but see if this works as you'd want it

May 16th, 2002, 11:18 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	or =INFO("directory") will just give you the path (no filename or sheetname) I seem to remember it may give you problems with network drive mappings, but see if this works as you'd want it __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 07:35 AM	#1
simp New Member Join Date: May 2002 Posts: 1	does anyone know if there is a function that will display the path to the workbook you are using in a cell? I'm using excel 97. Thank you. Simp

May 16th, 2002, 08:14 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	hi simp, try =CELL("filename",A1), where A1 is any cell in the book. this will give you the path, name of book and name of sheet, which you can crop using the LEFT and RIGHT functions. rgds mike