Ecxel Help Request

[Dirk Diggler]

GD is usually great for this...

I want to add the name of the last author in a cell. I have used this VBA code to do it, but it only adds the first name "Joe" but I want to to say "Joe Bloggs".

Function LastAuthor()
LastAuthor = ActiveWorkbook.BuiltinDocumentProperties("Last Author")
End Function

In the cell I put:

=LastAuthor()

 

[Dirk Diggler]

I just recreated that in a blank book and got both names
Using office pro plus 2013

Ah, I wonder if it's taken from the PC login details as opposed to the O365 user details.

 

[Dirk Diggler]

Changed PC account name but that doesn't help.

Hmm

 

[Dirk Diggler]

@Grrrrr thanks for that, I'll amend it.

 

[Dirk Diggler]

I don't know if I need to format the output somehow, as maybe it defaults to first name only. How could I tell what data is available?