austin350s10
Active Member
- Joined
- Jul 30, 2010
- Messages
- 321
Is there a way for a VBA script to reference a seperate file and return that files last saved time as a string?
I know how to check the last saved time of an active workbook but how can a dirfferent workbook that is not opened be checked?
If it helps I am only checking other .xlsm files nothing else.
I was using something like this but it only checks the active workbook:
I know how to check the last saved time of an active workbook but how can a dirfferent workbook that is not opened be checked?
If it helps I am only checking other .xlsm files nothing else.
I was using something like this but it only checks the active workbook:
Code:
Dim FileDate As String
FileDate = WorksheetFunction.Text(ThisWorkbook.BuiltinDocumentProperties("last save time").Value, "mm/dd/yyyy")