Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 05, 08:02 PM posted to microsoft.public.excel.worksheet.functions
cnestg8r
 
Posts: n/a
Default "last modified date"

How do I read the system "last modified date" and place it in a document
automatically?


  #2   Report Post  
Old December 9th 05, 08:13 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default "last modified date"


'-----------------------------------------------------------------
Function DocProps(prop As String)
'-----------------------------------------------------------------
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocument*Properties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function


and enter in a cell such as
=DocProps ("last author")
or
=DocProps ("last save time")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cnestg8r" wrote in message
...
How do I read the system "last modified date" and place it in a document
automatically?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
output date modified if data is entered for multiple rows [email protected] Excel Discussion (Misc queries) 4 October 13th 05 08:09 PM
How do I add the file last modified date into an Excel header? John_Ostar Excel Discussion (Misc queries) 3 October 10th 05 10:20 PM
dynamically enter name of last modified by in spreadsheet on save HW Excel Discussion (Misc queries) 1 June 28th 05 06:15 PM
How do I enter the date last modified in the footer of an Excel d. Last modified date in footer Excel Discussion (Misc queries) 1 February 7th 05 12:12 AM
Modified Date DME New Users to Excel 11 December 14th 04 08:15 PM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017