Auto-Insert "Last Saved By"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Good morning Barb Reinhardt

Does this help at all?

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

HTH

Dominic
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet change execution ends, but worksheet goes to never never 2
Last Saved By 3
Excel VBA 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
VBA - retrieve data on last create named range from previous inserted named range 0
INDIRECT.EXT problem with missing worksheets 7
Index, Large and Match?? 10
Syntax for getting value of named workbook range 1

Back
Top