Changing Author

D

dwake

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

Chip Pearson

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]
 
Top