Retrieve File Properties/Attributes

[Alan]

Hopefully again this is not a hard question and someone has been through this
before ... I have a piece of code that searches for all executable files
within a folder and returns me the Name, DateCreated, DeateModified, Version
etc,

However these files have an attribute/property calles 'Product Name'

Can anyone suggest how I can retrieve this information and update my table
accordingly

I am using FileSystemObjects however have searched here and over the net and
cannot find a way to retrieve this particular attribute/property

Any suggestions would be gratefully appreciated

 

[Daniel Pineault]

From what I know you need to use the DSO OLE file method, and you'll need to
install DSO. You can get it at http://support.microsoft.com/?id=224351

Here a post that covers the subject (you can google to find more
http://groups.google.ca/group/micro...O+file+Author+property+value#fc1aea0a0fd99acf

For basic scripting file properties you can take a look at
http://www.microsoft.com/technet/scriptcenter/guide/sas_fil_lunl.mspx?mfr=true
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[Alan]

Daniel

Many Thanks for that - Would you believe that was my previous post !! Moved
to access and forgot all about the code I had written in Excell

DOH !!!