Determine Full Path of an Opened XL File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vince - 16 May 2008 13:47 GMT

While having a workbook XL file opened, is there a way/menu selection
that will allow me to see the full file path (under Windows XPpro) ?
and possibly the date that the opened file was last revised?

I fear that I might have opened an outdated file and making data
revisions incorrectly.

Thanks.

Vince
Long Island, NY

Reply to this Message

GSalisbury - 16 May 2008 14:07 GMT

When I opened an .xls with my Excel97 the File Menu had it listed as File
#1.
File/Properties gave me access that File's info including various dates.
Selecting the General Tab and right-clicking the Filename exposed the whole
path.
Geo.

> While having a workbook XL file opened, is there a way/menu selection
> that will allow me to see the full file path (under Windows XPpro) ?
[quoted text clipped - 7 lines]
> Vince
> Long Island, NY

Reply to this Message

Jim Rech - 16 May 2008 14:30 GMT

IF you display the Web toolbar it will show the full path to the active
workbook.

Signature

Jim

|
| While having a workbook XL file opened, is there a way/menu selection
[quoted text clipped - 8 lines]
| Vince
| Long Island, NY

Reply to this Message

Vince - 16 May 2008 20:22 GMT

>IF you display the Web toolbar it will show the full path to the active
>workbook.

TnX Jim. I did not have the Web toolbar displayed.

Reply to this Message

Dave Peterson - 16 May 2008 14:47 GMT

Another way:

Find an empty cell and type this formula:
=cell("Filename",a1)

You'll see the drive, path, filename and sheet name like:
C:\My Documents\excel\[book1.xls]Sheet3

(The workbook has to be saved at least once, though.)

Signature

Dave Peterson

Reply to this Message

Vince - 16 May 2008 20:24 GMT

TnX Dave. Your suggestion will work nicely for me.

>Another way:
>
[quoted text clipped - 17 lines]
>> Vince
>> Long Island, NY

Reply to this Message