View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Edit File Properties: Title, Subject, Keywords, (MetaData) w/ VBA

see:

http://www.cpearson.com/excel/DocProp.aspx
--
Gary''s Student - gsnu200901


"Benjamin" wrote:

I'd like to edit the Title, Subject, & Custom Properties of some files.
right now *.dwg & *.xls.

What's the object or API to use to access the files document properties.
(You know the ones where you right click a file and go to the custom or
summary tab and look at the metadata, i.e. Title, subject etc).

I'd like to to be able to retrieve the data as well as write to it.

Could someone help get me started in the right direction here.