read the name of a saved file - put that value into a cell

[Max Bialystock]

Is it possible to read the name of a saved file and put that value into a
cell in that same workbook?

 

[Chip Pearson]

Max,

You can do this with a formula:

=SUBSTITUTE(MID(CELL("filename",A1),1,FIND("]",CELL("filename",A1
))-1),"[","")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Frank Kabel]

Hi David
if you mean the current workbook have a look at the following formulas:
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

 

[Max Bialystock]

Many thanks for your help.

Max

Max,

You can do this with a formula:

=SUBSTITUTE(MID(CELL("filename",A1),1,FIND("]",CELL("filename",A1
))-1),"[","")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Is it possible to read the name of a saved file and put that value into a
cell in that same workbook?

 

[Max Bialystock]

Frank,
Many thanks for your help,

Max

Hi David
if you mean the current workbook have a look at the following formulas:
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

--
Regards
Frank Kabel
Frankfurt, Germany

Is it possible to read the name of a saved file and put that value into a
cell in that same workbook?