Filename in Excel Cell Address

[RickS]

Is there a way to insert an excel spreadsheet filename into a cell within the
same spreadsheet, like the &[File] command in the Header/Footer screen?

 

[Gary Keramidas]

yes

=CELL("filename")

 

[Mike H]

Hi,

For the Fullname including path

=CELL("filename")

for the file name only

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Note the workbook must be save for this to work
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[RickS]

Thanks for your help Mike,

I used the ful path name and it works fine, except it also added the
"Sheet1" at them end, any way not to have that?
--
Thanks,
RickS

Hi,

For the Fullname including path

=CELL("filename")

for the file name only

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Note the workbook must be save for this to work
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

Is there a way to insert an excel spreadsheet filename into a cell within the
same spreadsheet, like the &[File] command in the Header/Footer screen?

 

[RickS]

thanks Mike,

I used the full file path approach and it is what I wanted, but it also
placed the "Sheet1" at the end, is there a way to suppress this?

 

[RickS]

thanks Gary,

is there a way to not get the "Sheet1" at the end of the path and filename?
--
Thanks,
RickS

yes

=CELL("filename")

--


Gary Keramidas
Excel 2003

Is there a way to insert an excel spreadsheet filename into a cell within
the
same spreadsheet, like the &[File] command in the Header/Footer screen?

.

 

[Gary Keramidas]

maybe this

=LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)
--


Gary Keramidas
Excel 2003

thanks Gary,

is there a way to not get the "Sheet1" at the end of the path and
filename?
--
Thanks,
RickS

yes

=CELL("filename")

--


Gary Keramidas
Excel 2003

Is there a way to insert an excel spreadsheet filename into a cell
within
the
same spreadsheet, like the &[File] command in the Header/Footer screen?

.

 

[Gord Dibben]

See the info and formula options at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP