Document Properties "Last Author" change to surname

you can use something like this to extract the surname, as the last word in the 'Last Author' string:

Please Login or Register  to view this content.

Not sure what you mean by the list though e.g. Windows account name not on this list" = "Unknown". Do you have a list of usernames somewhere, and are they stored in a workbook or hardcoded into the VBA?

Ah, I see. Something like this?

Please Login or Register  to view this content.

ah sorry, I think I understand now.

You want to manually insert a list of usernames in Column A, and a list of Surnames in Column B.

The macro checks the lastauthor name against this table, and uses it to update the last author saved to the file.

Is that correct? If so I'll try take another look at the code later

Just took a quick look at the documentation for this one: https://docs.microsoft.com/en-us/off...mentproperties

The 'Last Author' is stored as one of many document properties when a user saves a workbook. As far as I can tell it's only read-only, so you can't overwrite it using VBA (unless anyone else on the forum is aware of how to do this?)

The other challenge is that even if you could change it, when you save the file it will overwrite it with your own username...