Don,

Try ActiveWorkbook.Path

Best Regards

Bill
-----Original Message-----
Using Application.GetOpenFilename I can find what file
the user would like
to open. But before opening I want to be sure the file
isn't already open.
Having the filename I can loop through the set of
Application.Workbooks and
check. Problem is the GetOpenFilename returns the full
pathname, and
Workbooks is a list of filenames only. So how do I easily
extract the
filename from the pathname? I looked around and could not
find a function.
If I have to I can loop through the name, find the slash
(or colon), and do
a Right. But I would think that there is an easier way.

Thanks, Don <donwiss at panix.com.
.