interesting. I am not sure then why its not working. All I know is that I
did not write the spreadsheet and want to ask questions to the person who
did.. They are saved as read only, would that make a difference?

"Jim Thomlinson" wrote:

That line of code works for me. It returns the user name as defined in Tools
- Options - General - User Name. Of course the value stored in this is at
the users discression, which may be the problem that you are having. Were you
wanting the login name of the person who created the file (this is maintained
by the operating system and is not at the discression of the user)? It is the
same difference as

Application.username
and
Environ("userName")
--
HTH...

Jim Thomlinson


"Todd" wrote:

I have a macro script that I thought would tell me that but it returns that
I did. It is open on my desktop but I didn't create it. Is there a way to
find out who origonally created a workbook?


Sub WhoWroteThis()
MsgBox ThisWorkbook.BuiltinDocumentProperties.Item("Autho r")
End Sub

Thanks,

Todd