Change document properties
 

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!

Change document properties
 

ThisWorkbook.BuiltinDocumentProperties("Title")="N ew Documentation"

"Suter" wrote in message
...
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!

Change document properties
 

Zone schrieb:

ThisWorkbook.BuiltinDocumentProperties("Title")="N ew Documentation"

Great! Thanks!

Change document properties
 

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

--
---
HTH

Bob

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



"Suter" wrote in message
...
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!