change file summary

[HebieBug]

Am working on a small bit of code that produces a list of all files inside a designated folder. It puts the list into excel with some of the file summary items ie title, author.
Am currently using FileSystemObject to get the info.
I then want to do some modifications by hand.
After the modification I then want to populate changes back to the file.

I can get the summary of the file but I would not have a clue how to save the changes back.
Anyone have any code that can show me how to modify the summary of a file in VBA?

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/224351

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fumei]

Here are your choices.

1. Using DSO, as PHV points you to to.

2. Actually opening the file, writing to the properties, saving and closing the file.

I do not know of any other method.

faq219-2884

Gerry
My paintings and sculpture