How do I Access, File Properties, of Non-office files?

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

Benjamin

I'd like to access the file properties of non-office files.
I've got drawing files, pdf, and several other formats.
It's got to be some sort of generic way to edit the custom value of the file.

i.e. right click a file, properties, summary tab, title, subject, author,
category etc.... sometimes I get a custom tab with additional values..

I'd like to be able to read and write to those fields in a file. I believe
it the metadata of a file.

Can someone lead me in the right direction here?
 
Look at the Ms wia dll it allows you to read write image properties
BUT not IPTC or XMP or Picasa People or GPS tags

Using shell
Sub tryita()
Dim DSO As DSOFile.OleDocumentProperties
Dim CustProps As DSOFile.CustomProperties
Dim ii As Integer


Set DSO = New DSOFile.OleDocumentProperties

DSO.Open "c:\5\dscf1220.jpg", True, dsoOptionDefault
Set CustProps = DSO.CustomProperties
Cells(2, 2) = CustProps.Count

For ii = 0 To CustProps.Count
Cells(ii + 5, 3) = CustProps(ii).Name
Cells(ii + 5, 6) = CustProps(ii).Value
Next ii

DSO.Close


End Sub
Gives a combination of the KeyWords from both groups which can be merged..

AND then writen using wia...

The Windows API Code pack ... dll
and Microsoft.WindowsApiCodePack.Shell ...DLL
Seem to ofer a solution IF ANYONE can get the dll that will reference from
excel

HELP Help and F1
Harry S
 
Back
Top