which is a read-only setting and hence no good to you.

It is not a read-only setting. You can set the 'Author' property
with code:

ThisWorkbook.BuiltinDocumentProperties("Author").V alue = _
"New Author Name"
MsgBox ThisWorkbook.BuiltinDocumentProperties("Author").V alue



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"dominicb"
wrote in message
...

Hi Tom

Unfortunately not. According to Excel's help files the only
way to
access the author name is to use theBuiltInDocumentProperties
structure
thus:

Sub Test()
a = ActiveWorkbook.BuiltinDocumentProperties("Author") .Value
MsgBox a
End Sub

which is a read-only setting and hence no good to you.
Although using
legitimate instructions, XL doesn't seem to like communicating
all file
properties to Access. Stumped!

Sorry I cannot be of any further help.

DominicB


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