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 - 19 Sep 2007 09:36 GMT
ThisWorkbook.BuiltinDocumentProperties("Title")="New Documentation"
> Hello
>
[quoted text clipped - 6 lines]
>
> Thanks for helping!
Suter - 19 Sep 2007 09:48 GMT
Zone schrieb:
> ThisWorkbook.BuiltinDocumentProperties("Title")="New Documentation"
Great! Thanks!
Bob Phillips - 19 Sep 2007 10:03 GMT
ActiveWorkbook.BuiltinDocumentProperties("Title") = "myTitle"

Signature
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> Hello
>
[quoted text clipped - 6 lines]
>
> Thanks for helping!