ExcelBanter - Auto-Insert "Last Saved By"

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Auto-Insert "Last Saved By" (https://www.excelbanter.com/excel-worksheet-functions/43297-auto-insert-%22last-saved-%22.html)

Barb Reinhardt

Auto-Insert "Last Saved By"

I'm trying to determine that "Last Saved By" names for multiple workbooks.
I've been searching for a worksheet function, but think I'll probably have to
use VBA to do this. Any suggestions?

Thanks,
Barb Reinhardt

dominicb

Good morning Barb Reinhardt

Does this help at all?

MsgBox ActiveWorkbook.BuiltinDocumentProperties("Last Author").Value

HTH

DominicB

--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=428375

All times are GMT +1. The time now is 08:47 AM.