Change document properties

[Suter]

Hello

In Microsoft Excel --> File --> Properties --> Summary.
There are plenty of fields: Title, Subject, Author, Manager, Company,
Category etc.

I need to change the values (for example set Titel: New Documentation ).
How can I do it in VAB?

Thanks for helping!

 

[Zone]

ThisWorkbook.BuiltinDocumentProperties("Title")="New Documentation"

 

[Suter]

ThisWorkbook.BuiltinDocumentProperties("Title")="New Documentation"

Great! Thanks!

 

[Bob Phillips]

ActiveWorkbook.BuiltinDocumentProperties("Title") = "myTitle"

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)