>Thanks for the hint, but I've already looked there. There is nothing that looks like File properties, nor can I find the names of those properties by their name. Any other idea?
Check out the BuiltinDocumentProperties collection for your workbook and documents. Example:
Excel
ActiveWorkbook.BuiltinDocumentProperties("Author").Value = "My Name Here"
Word
ActiveDocument.BuiltinDocumentProperties("Author").Value = "My Name Here"
It is relatively obscure in the VBA help. Maybe Della and Tamar covered it better in their book.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao
