About Us

k2224z

Thank you this worked.

"Gord Dibben" wrote:

First off.........save a backup of your workbook.

Then use this User Defined Function

Function DocProps(prop As String)
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

'=DOCPROPS("last author")
'or
'=DOCPROPS("last save time")
'or
'DOCPROPS("creation date")

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the above code in there. Save the
workbook and hit ALT + Q to return to Excel window.

Enter the formula as shown above.

Gord Dibben Excel MVP

On Mon, 28 Aug 2006 15:28:02 -0700, k2224z
wrote:

how do I show the last date that the file was saved in a cell in the file

Gord Dibben MS Excel MVP

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date format issue	CindyLF1	New Users to Excel	3	June 12th 06 06:18 PM
Excel date format trouble	michaelberrier	Excel Discussion (Misc queries)	2	April 21st 06 05:21 AM
Excel: I enter date and format for date, but shows as number	spohar	Excel Discussion (Misc queries)	2	March 10th 06 08:40 PM
Excel date field link to Word	Earl	Excel Discussion (Misc queries)	1	July 13th 05 11:20 PM
Excel enters date as a text format	Kane	Excel Discussion (Misc queries)	3	March 22nd 05 09:20 PM

Menu

About Us