Function to insert current filename into worksheet?

  • Thread starter Thread starter Ginko
  • Start date Start date
G

Ginko

Hi

I'd like to know if there is a function that I can use to put the current
fileame into a cell in my worksheet?

Thanks
 
I just learnt this from other helpful people in this Discussion Group. It
will return the latest worksheet name to you, if change "]" to "[" and 1 to
0, then will give you file name and sheet name. See what you wants it and do
a little modification.

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

This is a link they refer to, have a look/
http://www.xldynamic.com/source/xld.xlFAQ0002.html

Hope it helps.
 
And remember that without the range reference:
=CELL("filename",A1)

You'll get the info from worksheet/workbook that is active when excel
recalculates.

Bob goes into more info at the link.

Learn-more said:
I just learnt this from other helpful people in this Discussion Group. It
will return the latest worksheet name to you, if change "]" to "[" and 1 to
0, then will give you file name and sheet name. See what you wants it and do
a little modification.

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

This is a link they refer to, have a look/
http://www.xldynamic.com/source/xld.xlFAQ0002.html

Hope it helps.

Ginko said:
Hi

I'd like to know if there is a function that I can use to put the current
fileame into a cell in my worksheet?

Thanks
Click to expand...
Click to expand...
 
Back
Top