Using document properties

[ingalla]

I want to be able to update a Microsoft Access table with data relating to
word documents. Each document has a custom property called SOP Number, i
want to be able to drag this property data out of each document and populate
an access table. I also want to be able to pull out the creation date,
authur, and other bits and pieces.

The question is, is this possible, and if so, how would I do it?

Thanks in advance for any help

 

[Jonathan West]

I want to be able to update a Microsoft Access table with data relating to
word documents. Each document has a custom property called SOP Number, i
want to be able to drag this property data out of each document and
populate
an access table. I also want to be able to pull out the creation date,
authur, and other bits and pieces.

The question is, is this possible, and if so, how would I do it?

Thanks in advance for any help

Getting access to the Document Properties of a Word file
http://www.word.mvps.org/FAQs/MacrosVBA/DSOFile.htm


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Doug Robbins - Word MVP]

Certainly it is possible.

You will get some tips from the last of the articles in the following series

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136

and there is more that will be applicable in the article "Find & ReplaceAll
on a batch of documents in the same folder" at:

http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP