Change properties thru Macro

[Drdave1958]

I tried to record a macro to change some of the open workbook properties, specifically the author, company and comments but was unsuccessful. Is there VB code to do this? If so, can I also change attributes?

Thanks, Dave

 

[Andrew Poulsom]

Use the BuiltinDocumentProperties property eg:

ThisWorkbook.BuiltinDocumentProperties.Item("Author") = "DrDave"

 

[Drdave1958]

Thanks, Andrew