PeterMac65
New Member
- Joined
- May 7, 2020
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi,
I'd like to get the name of the author who last saved the files
I can get the FileDateTime but cant see how best to get the author.
Can someone point me in the right direction
Regards Peter
exist = Dir(coster_folder & "\" & "*.xlsm")
While exist <> ""
Cells(r, 7).Value = Format(FileDateTime(coster_folder & "\" & exist), "yyyy-mm-dd h:mmampm")
r = r + 1
exist = Dir
Wend
I'd like to get the name of the author who last saved the files
I can get the FileDateTime but cant see how best to get the author.
Can someone point me in the right direction
Regards Peter
exist = Dir(coster_folder & "\" & "*.xlsm")
While exist <> ""
Cells(r, 7).Value = Format(FileDateTime(coster_folder & "\" & exist), "yyyy-mm-dd h:mmampm")
r = r + 1
exist = Dir
Wend