ExcelBanter - Changing Author

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing Author (https://www.excelbanter.com/excel-discussion-misc-queries/249995-changing-author.html)

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

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?