User Stamp

[Mr. Walnuts]

Ok, if someone creates an Excel workbook, excel automatically notes that user as the "Author" of the workbook; where does excel get that information?

I have a VBA Procedure that Date / Time stamps the workbook based on the 'change' event; but I would like it to also "user stamp" it as well so recipients know who last updated the document, but I don't know where excel gets the information on the current windows user.

Does anyone know what that object/property is called?

 

[lenze]

Either

Environ("UserName") or Application.UserName

The first returns the network log-in name.
The 2nd returns the Application Name found in Tools>Options>General Tab / This can, of course, easily be changed. I'm 99% sure you want to use Environ

lenze

 

[Mr. Walnuts]

Out-friggin-standing

Option 1 was EXACTLY what I was looking for.

 

[lenze]

I use a comment to track this. See my article here
http://vbaexpress.com/kb/getarticle.php?kb_id=909

lenze

 

[Mr. Walnuts]

Great Article!

I bookmarked it for future use.
For this application though, it's primarily for recipients that print out the Maint sheet from the workbook. One of the other users added a Today() value at the top that confuses the crap out of people and inaccurately implies the sheet was updated the same day it was printed. I just wanted to get rid of the misleading time/date and add the "Last Updated By" stamp for GP.

thank you though.

 

[lenze]

You might also have a look at "BuiltInDocumentProperties"

lenze