Update Properties values in Explorer

[maruapo]

Hi:

I need to figure out the VBA---either run by a Word or Excel macro, it doesn't matter---that cycles through all PowerPoint, Excel, and Word documents in a folder and then updates the following property fields: Title, Subject, Author, Category, and Keywords. I can use Application.InputBox to input data for any of these fields.

I know the code to retrieve file names, and open files from this folder, but for the life of me I can't figure out how (or if it's even possible) to update the aforementioned fields via VBA. Is it possible? The alternative is to manually open each file and update the properties fields, but I have hundreds of files to work with here and a macro would be ideal.

Any advice?

 

[Ruddles]

This doesn't appear to be a trivial exercise judging by the lack of usable code I've found using Google. Presumably you've tried Googling for this topic?

The most useful link appears to be this one: http://www.cpearson.com/Excel/DocProp.aspx