It's probably better in this case to include a cell from that worksheet:

=cell("filename",a1)
(any old cell will do)


If you open two workbooks and put:
=cell("Filename")
in A1 of a worksheet in each workbook
then use window|arrange|tiled
to see both worksheets,
you'll see the difference.

Gary''s Student wrote:

Use =CELL("filename") and parse out the part of the string that you need.
--
Gary's Student

"Pradhan" wrote:

Is there anyway to pull either the complete path or alternatively, the parent
folder of the xls file. For example, example.xls is located in the
c:\november directory,
I'd like to pull in either C:\november or just november.

Thanks
Pradhan

--

Dave Peterson