In windows explorer if you right click on the file you will be able to select
properties and view most of the properties of that file. You can also open
the file and look at File - Properties.

That will give you the bulk of the metadata for that file. There is a little
more metadata but you need to be a little fiendish to view it and I don't
think that any of it would be of value to you.

Is the workbook shared? I am not to sure what all that would affect in terms
of what you are looking for.
--
HTH...

Jim Thomlinson


"Todd" wrote:

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