How to find file-path of open workbook?

L

Larryq22

Sometimes when I return to an Excel workbook that's been open for a while, I
need to check it's path. I've been doing a file...save as and looking there,
but I'm thinking there must be an easier way. Is there something I'm missing?

Thanks,
Larry
 
J

Jon Peltier

Do you know VBA? If so, in the immediate window type

?ActiveWorkbook.Path

and press Enter.

- Jon
 
S

Stefi

Type ?Activeworkbook.FullName
in VBA Immediate window and press Enter!
Regards,
Stefi


„Larryq22†ezt írta:
 
G

Gary''s Student

the formula:
=CELL("filename",A1)
will return the path and filename once he file has been saved.
 
D

Dave Peterson

One more:

File|Properties|General Tab

(sometimes long paths are truncated, though)
 
B

Bob

Is your OS Vista? If so to copy the full path to the clipboard. Shift-Right
Click on a file or folder and choose Copy as Path.
 
R

Ragdyer

You can add the "Address" box to your menu bar or tool bar.
This will display the full path of any saved file.
I would advise using the Menu bar, since there's usually more room there,
and paths can get to be rather long.

Right click on the tool bar and choose "Customize".
Under the "Commands" tab, scroll down in the left window and click on "Web".

Then, from the right window, click and drag the "Address" box to your Menu
bar.
While it's *still* selected on the Menu bar, hover the cursor over the right
border until it changes to a double headed arrow.
Drag the border to the right to enlarge the box so as to see the entire path
of any deeply buried WB you might open.

Then just close the "Customize" window.
 
Top