must capture document properties for word, excel and powerpoint documents

Question

Hi, I am new to VBA and this area. I would like to capture the document proporties like (document title, subject, author, team, manager,company etc...) while create or saving the document. This properties capture is must and i would like to implement to all the Word, Excel, Powerpoint users in my company. How this can be possible. If I wrote a macro, is it possible to deploy all the MS-Office users. or a VB program will do?. All i need is to make mandatory to input document properties for all the documents. these properties can also be fetched from a template file from the user machine. Is this possible in VBA or any other easy ways to do it.

Answer 1

If you just want to be able to read (or modify) the properties, you can use the Office Document Property Reader to read and write properties of Office documents, without even needing Office installed. That works across all Office applications.

Answer 2

To force users to fill in all the properties before saving the document, you can create add-ins (one for each of Excel, Word and PowerPoint) that intercept the "before save" event and check the document properties. If the add-in detects some properties that have not been filled in, it can prompt the user and cancel the save.

The means by which you can create an add-in is similar (but not identical) across the 3 applications. You would of course also have to ensure that the add-ins were installed on all your users machines.