View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Last Modified Date

Hi
you may use the following user defined function:
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties (prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

Now you can use the following formula in one of your cells:
=DocProps("Last save time")


--
Regards
Frank Kabel
Frankfurt, Germany

Dominique Feteau wrote:
Is there some script that I can use to insert the last modified date
of a workbook into a specific cell??

Dominique