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!

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

"Suter" <(E-Mail Removed)> wrote in message
news:7poxm1xrswly$.(E-Mail Removed)...
> 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 schrieb:

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

Great! Thanks!

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

--
---
HTH

Bob

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



"Suter" <(E-Mail Removed)> wrote in message
news:7poxm1xrswly$.(E-Mail Removed)...
> 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!