Determine Full Path of an Opened XL File

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

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
 
IF you display the Web toolbar it will show the full path to the active
workbook.

--
Jim
|
| 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
 
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.)
 
TnX Dave. Your suggestion will work nicely for me.

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.)
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
Click to expand...
Click to expand...
 
Back
Top