Thread: Date in Page...
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
use the following UDF (only on workbook level):


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


and enter in a cell
=DOCPROPS("last save time")
(format cell as date)


"The Boondock Saint" wrote:

Hi guys,
Im just wondering how I can have the the time and date in a sheet....
basically im saving the sheet as a webpage.. and just want to have the time
and date it was saved included....

Hope someone can help out..

Cheers....