best way to get ss current directory and filename?

[Scott]

Hello, whats the most effective way to get the current spreadsheet's
directory and filename??

 

[Norman Harker]

Hi Scott!

Try:
=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1)

=CELL("filename",A1)

Returns full path including sheet name.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Peo Sjoblom]

For filename


=LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".",
MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3)

will work unless there is a really funky name
for directory/folder name


=RIGHT(LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-2),LEN(LEFT(CE
LL("filename",A1),FIND("[",CELL("filename",A1))-2))-SEARCH("^^",SUBSTITUTE(L
EFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-2),"\","^^",LEN(LEFT(C
ELL("filename",A1),FIND("[",CELL("filename",A1))-2))-LEN(SUBSTITUTE(LEFT(CEL
L("filename",A1),FIND("[",CELL("filename",A1))-2),"\","")))))

--

Regards,

Peo Sjoblom

Hi Scott!

Try:
=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1)

=CELL("filename",A1)

Returns full path including sheet name.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hello, whats the most effective way to get the current spreadsheet's
directory and filename??