Set Excel Author Option?

**tkstock** · 06-14-2005, 03:17 PM

I did a search on the forums to no avail...

Can you programmatically change the default Author setting for Excel? I see you can return it, but I can't see how to set it!

I am running an Access database which allows users to export data to Excel. When they do this, however, I want their username to be the Author attribute of the documents that they create. How can I do this? I can set the attribute for an individual workbook, but I want to change it in their Excel options.

Thanks!!

**dominicb** · 06-14-2005, 03:25 PM

Good evening Tom

Try going to Tools > Options, General tab, Username.

This is the name that Excel uses as the author in the file properties.

HTH

DominicB

**tkstock** · 06-14-2005, 03:31 PM

I appreciate your post, however, I am looking to do this programatically. I know how to do this manually.

**dominicb** · 06-14-2005, 03:53 PM

Hi Tom

I answered the question that you asked using the information you supplied. In the light of what you've just posted, this might help.

Sub Test()
Application.UserName = "DominicB"
End Sub

HTH

DominicB