Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File, properties, title
Can I (both read and) set the 'Title' attribute for a file using VBA ? Is it
possible ? If not, are you aware of any alternative tools I might use ? I need to open a file, search for a string in that file, get the value next to that string then set the 'Title' attribute of the file to the value found. Thanks, Eric. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File, properties, title
Use
activeworkbook.BuiltinDocumentProperties("Title") -- HTH Bob Phillips "Eric" wrote in message ... Can I (both read and) set the 'Title' attribute for a file using VBA ? Is it possible ? If not, are you aware of any alternative tools I might use ? I need to open a file, search for a string in that file, get the value next to that string then set the 'Title' attribute of the file to the value found. Thanks, Eric. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File, properties, title
activeworkbook.BuiltinDocumentProperties("Title")
I understand this is read only, can it be written to ? Regards, Eric. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File, properties, title
From the immediate window:
Activeworkbook.BuiltinDocumentProperties("Title"). Value = "Doghouse" ? Activeworkbook.BuiltinDocumentProperties("Title"). Value Doghouse Activeworkbook.BuiltinDocumentProperties("Title"). Value = "Thor" ? Activeworkbook.BuiltinDocumentProperties("Title"). Value Thor So looks like the answer is yes. -- Regards, Tom Ogilvy "Eric" wrote in message ... activeworkbook.BuiltinDocumentProperties("Title") I understand this is read only, can it be written to ? Regards, Eric. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
File, properties, title
Thanks to you both.
Eric. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing 'title' from properties in header | Excel Discussion (Misc queries) | |||
Why is the name I gave file not showing up in title bar when file | Excel Discussion (Misc queries) | |||
Properties - Title Corruption Virus? | Excel Discussion (Misc queries) | |||
Want file title listing as in Excel 5.0 File>Find | Excel Discussion (Misc queries) | |||
How do I get the file properties? | Excel Programming |