How to find file-path of open workbook?
 

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

How to find file-path of open workbook?
 

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

?ActiveWorkbook.Path

and press Enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Larryq22" wrote in message
...
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

How to find file-path of open workbook?
 

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


€žLarryq22€� ezt Ã*rta:

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

How to find file-path of open workbook?
 

the formula:
=CELL("filename",A1)
will return the path and filename once he file has been saved.
--
Gary''s Student - gsnu200765


"Larryq22" wrote:

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

How to find file-path of open workbook?
 

=CELL("filename",A1)
--
David Biddulph

"Larryq22" wrote in message
...
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

How to find file-path of open workbook?
 

One mo

File|Properties|General Tab

(sometimes long paths are truncated, though)

Larryq22 wrote:

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

--

Dave Peterson

How to find file-path of open workbook?
 

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.

"Larryq22" wrote in message
...
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

How to find file-path of open workbook?
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Larryq22" wrote in message
...
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