http://www.cpearson.com/excel/docprop.htm

look toward the bottom of the page.

--
Regards,
Tom Ogilvy


"Steven" wrote:

I have seen:
BuiltInDocumentProperties("Last Author") but this means the file must be open.

And I have seen:
myFile = "C:\Book1.xls"
FileDateTime(myFile)
..This means the file does not have to be open and I can have a list in
Column A to return the FileDateTime.

Question: Is there a way to get the Last Author somewhat in the same way
that the FileDateTime is returned?

Thank you for your help.

Steven.