I used to use a formula that would give the worksheet name, file name and
file path in an excel worksheet. I think the last time I used it might have
been in Office 97.

I am trying to do it again in Excel 2003 but can't seem to find the function.

Can anyone advise what it is or is it something that was dropped between
versions for Excel?

I know Page Setup / Footer is an alternative but I was trying avoid it.

Thanks

=CELL("filename",A1)

--
Gary''s Student - gsnu200768


"Graeme" wrote:

I used to use a formula that would give the worksheet name, file name and
file path in an excel worksheet. I think the last time I used it might have
been in Office 97.

I am trying to do it again in Excel 2003 but can't seem to find the function.

Can anyone advise what it is or is it something that was dropped between
versions for Excel?

I know Page Setup / Footer is an alternative but I was trying avoid it.

Thanks

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Graeme" wrote in message
...
I used to use a formula that would give the worksheet name, file name and
file path in an excel worksheet. I think the last time I used it might
have
been in Office 97.

I am trying to do it again in Excel 2003 but can't seem to find the
function.

Can anyone advise what it is or is it something that was dropped between
versions for Excel?

I know Page Setup / Footer is an alternative but I was trying avoid it.

Thanks