Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file attributes via macro
Hi ,
is it possible to get an open excel file's attributes via macro e.g last modified date or created date. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
file attributes via macro
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 "SUNIL" wrote in message ... Hi , is it possible to get an open excel file's attributes via macro e.g last modified date or created date. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
file attributes via macro
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) "Rob van Gelder" wrote in message ... 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 "SUNIL" wrote in message ... Hi , is it possible to get an open excel file's attributes via macro e.g last modified date or created date. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
Getting NTFS file attributes | Excel Discussion (Misc queries) | |||
File Attributes | Excel Discussion (Misc queries) | |||
? ABTAIN FILE ATTRIBUTES WITH MACRO | Excel Programming | |||
syntax of changing file attributes | Excel Programming |