Function to insert current filename into worksheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ginko - 07 May 2008 10:58 GMT

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

Reply to this Message

Learn-more - 07 May 2008 11:24 GMT

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.

> 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

Reply to this Message

Dave Peterson - 07 May 2008 12:32 GMT

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.

> 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
[quoted text clipped - 14 lines]
> >
> > Thanks

Signature

Dave Peterson

Reply to this Message