View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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.