Date in Page...

[The Boondock Saint]

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

 

[Frank Kabel]

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]

well with abit of playing around.. ive found the NOW function....

This shows the current date and time and is perfect.... im wondering is
there anyway to include this into another function.. such as the CONCATENATE
function

Cheers

 

[Frank Kabel]

Hi
try to explain what you're trying to achieve with this. Of course you could
include NOW() or TODAY() in another function. e.g.
="The vcurrent date is: " & TEXT(TODAY(),"MM/DD/YYYY")