nikki333
07-27-2017, 12:48 PM
Dear All,
I'm a total beginner and would be glad to get some help about retrieving document properties.
It seems no problem to retrieve the built in properties for the currently opened file (like shown below), but i want to get this info from another file.
Function UDatum()
Application.Volatile
UDatum = ActiveWorkbook.BuiltinDocumentProperties("Last save time")
End Function
So, I thought, I'd replace the ActiveWorkbook. part with the file location like so:
Workbooks("C:\workbook_***.xlsm").BuiltinDocumentProperties("Last Author")
That file should not be opened, just the properties should be read. Any help?
I'm a total beginner and would be glad to get some help about retrieving document properties.
It seems no problem to retrieve the built in properties for the currently opened file (like shown below), but i want to get this info from another file.
Function UDatum()
Application.Volatile
UDatum = ActiveWorkbook.BuiltinDocumentProperties("Last save time")
End Function
So, I thought, I'd replace the ActiveWorkbook. part with the file location like so:
Workbooks("C:\workbook_***.xlsm").BuiltinDocumentProperties("Last Author")
That file should not be opened, just the properties should be read. Any help?