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!!


--
tkstock


------------------------------------------------------------------------
tkstock's Profile: http://www.excelforum.com/member.php...o&userid=14443
View this thread: http://www.excelforum.com/showthread...hreadid=379129

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=379129

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

--
tkstoc

-----------------------------------------------------------------------
tkstock's Profile: http://www.excelforum.com/member.php...fo&userid=1444
View this thread: http://www.excelforum.com/showthread.php?threadid=37912