Retrieving Doc Variables AND/OR Custom Doc Props From All Documents in a Folder

[nzjrs]

Hey,

I am building a VBA application to mine the data from many wor
documents located within a folder. I am using the dsofile.dll to ge
all of the built in properties, but this doesnt work for other documen
variables.

HOW WOULD I MINE A DOCUMENT VARIABLE CALLED \"VERSIONNUMBER\" FROM AL
OF THE FILES IN A DIRECTORY

The dll does support custom document properties though, Indeed thi
raises my second question;

What are the differences between custom document properties an
document variables? And which would be better for my application o
storing decimal version numbers, and revision strings within a wor
AND/OR excel document?

HOW WOULD I USE THIS DSOFILE.DLL TO GET CUSTOM DOCUMENT PROPERTIES FRO
ALL THE DOCUMENTS IN A FOLDER

Finally

WHICH OF THE TWO APPROACHES DO YOU THINK WILL BE FASTER

Thanks
Joh

 

[Jezebel]

You'll get better answers if you don't shout.

Document variables and document properties are very similar: both can be
included in the body of the document using fields, and from the coding point
of view they are almost identical. The main difference is that custom
document properties are accessible to the user via the File > Properties >
Custom tab. Document variables are accessible only through VB or VBA.

Excel workbooks don't have Document Variables, so if you're processing both,
docproperties might be better: you can pass any office document as an object
retrieve the properties using exactly the same code.

Speed is not an issue either way: most of the time will go in opening and
closing the files themselves. The time taken to retrieve the properties or
variables won't be measurably different.