File Properties
 

Is there a way to change the details in the Summary tab of the File
Properties dialog box (e.g. Title / Keywords / Comments) through using a
macro?

Thanks,

Andrew

activeworkbook.BuiltinDocumentProperties("title") = "Test book"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andrew" wrote in message
...
Is there a way to change the details in the Summary tab of the File
Properties dialog box (e.g. Title / Keywords / Comments) through using a
macro?

Thanks,

Andrew

Exactly what I was looking for.

Thanks,

Andrew

"Bob Phillips" wrote:

activeworkbook.BuiltinDocumentProperties("title") = "Test book"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andrew" wrote in message
...
Is there a way to change the details in the Summary tab of the File
Properties dialog box (e.g. Title / Keywords / Comments) through using a
macro?

Thanks,

Andrew