You can use the "BuiltInDocumentProperties" property of the workbook.
From the help file...
ActiveWorkbook.BuiltinDocumentProperties.Item("Tit le") _
.Value = "Year-End Sales Results"
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(30 different ways to sort in excel)





"hutteto"
wrote in message
...
Hey,

I am needing to write to the Summary properties of a file.
The properties are the ones in the Summary tab of a file (When you
right click on a file, then click on the properties tab, then click on
the Summary tab - you will see Title, Subject, Author, Category,
Keywords, Comments). These are the properties I am trying to WRITE.

I cannot use DSO, so DSO is not an option.

I have found that these properties are actually stored in a seperate
hidden file that is attached to the main file I am trying to change
the properties for. These are called NTFS Alternate Data Streams.
http://users.telenet.be/ws36637/properties.html

Problem is I cant figure out how to write to these files(i.e.
properties)
How would I be able to do this in VBA?

Thanks
Todd