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.

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.

File, properties, title
 

activeworkbook.BuiltinDocumentProperties("Title")

I understand this is read only, can it be written to ?

Regards, Eric.

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.

File, properties, title
 

Thanks to you both.

Eric.