file attributes via macro

S

SUNIL

Hi ,

is it possible to get an open excel file's attributes via macro e.g last
modified date or created date.

Thanks
 
R

Rob van Gelder

Sub testit()
Dim dpr As DocumentProperty

On Error Resume Next
For Each dpr In ActiveWorkbook.BuiltinDocumentProperties
Select Case dpr.Name
Case "Creation date", "Last save time": MsgBox dpr.Name & ": " &
dpr.Value
End Select
Next
End Sub

Rob
 
B

Bob Phillips

Sunil,

Look up BuiltinDocumentProperties Property in VBA Help to see what
properties are available.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top