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?

Try searching this forum for file system objects
--
HTH...

Jim Thomlinson


"Benjamin" wrote:

> 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?

I have code to get and set both custom and built-in properties from
open or closed workbooks at

http://www.cpearson.com/excel/DocProp.aspx

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 15 Sep 2009 08:56:01 -0700, Benjamin
<(E-Mail Removed)> wrote:

>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


"Benjamin" wrote:

> 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?