The following code will change the author name:

ThisWorkbook.BuiltinDocumentProperties("Author"). _
Value = "Author Name"

See http://www.cpearson.com/excel/DocProp.aspx for much more code
working with both built-in and custom document properties.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Thu, 3 Dec 2009 06:54:02 -0800, dwake
wrote:

Anybody know if I can use VBA to automatically change the author of an excel
file when I run a macro?