ExcelBanter - Who saved the file?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Who saved the file? (https://www.excelbanter.com/excel-programming/361242-who-saved-file.html)

Who saved the file?

Anyone know how to find out who last modified a file? Not obvious in VBA
- maybe an API call? Cheers

--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=541291

Who saved the file?

Will the "Last Author" property work?

Debug.Print ThisWorkbook.BuiltinDocumentProperties("Last
author").Value

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"colofnature"
wrote
in message
...

Anyone know how to find out who last modified a file? Not
obvious in VBA
- maybe an API call? Cheers

--
colofnature
------------------------------------------------------------------------
colofnature's Profile:
http://www.excelforum.com/member.php...o&userid=34356
View this thread:
http://www.excelforum.com/showthread...hreadid=541291