Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
You need a udf
Function DocProps(prop As String) Aplication.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function You would use like so =DOCPROPS("last save time") -- HTH RP (remove nothere from the email address if mailing direct) "Denny" wrote in message ... How can I access and display, from within a worksheet cell, the modified date in FIle-Properties? In Word you can insert the "Field" in the document. How can this be done in Excel? Thanks, Denny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
How can you print file properties in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Extracting File Names and Properties | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do I show some of the file properties in a cell in a work she. | Excel Worksheet Functions |