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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an author field in Excel? 4
Author name edit 4
copy author in cell 1
Excel 2003 - Color changing cells 1
How do I change the author on an Excel spreadsheet? 2
Document Properties for Office 2007 Excel Templates 4
Error Starting MS Help 3
Disable Macro Alert 2

Top