| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to print file properties in excel? | Excel Discussion (Misc queries) | |||
| Where does Excel get the default properties without startup file? | Excel Discussion (Misc queries) | |||
| Printing/Displaying File Properties | Excel Discussion (Misc queries) | |||
| How can you print file properties in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I show some of the file properties in a cell in a work she. | Excel Worksheet Functions | |||
Linear Mode
