Function to insert current filename into worksheet?
 

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

Function to insert current filename into worksheet?
 

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" wrote:

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

Function to insert current filename into worksheet?
 

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 wrote:

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" wrote:

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

--

Dave Peterson