You may want to use:

=cell("filename",a1)

If you have multiple workbooks open, then this formula will evaluate to the
activeworkbook.

If you try it with two workbooks open (and windows arranged nicely), you'll see
the problem.

netorius77 wrote:

Too smart by far - thanks exactly what I wanted.

"Gary''s Student" wrote:

Yes.

Use the =CELL("filename") function

Have a good day
--
Gary''s Student


"netorius77" wrote:

I am using Excel 2003. I know how to insert the full path and file name in a
footer, however, is there any way (possibly a function) to display the full
path and file name in a cell?

--

Dave Peterson