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