D dwake Dec 3, 2009 #1 Anybody know if I can use VBA to automatically change the author of an excel file when I run a macro?
Anybody know if I can use VBA to automatically change the author of an excel file when I run a macro?
C Chip Pearson Dec 3, 2009 #2 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]
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]
