Search for file, using properties 'Title'

[Firery]

Thanks for even looking,

I'm trying to write a code in VBA (Excel) to search for a file with a specific value in it's builtindocumentproperties "Title".

With Filesearch, I can search using 'TextOrProperties',
but I only want to find a file with a specific property (title).

Hope someone can help.

 

[Remou]

How about:

Set fs = Application.FileSearch
strLookIn = "C:\Docs\"
With fs
    .NewSearch
    .FileName = "*.xls"
    .LookIn = strLookIn
    .SearchSubFolders = False
    .PropertyTests.Add "Title", msoConditionIncludes, "ThisText"
    If .Execute > 0 Then
        For Each varFile In .FoundFiles
            Debug.Print varFile
        Next varFile
    End If
End With

--

http://www.microsoft.com/technet/prodtechnol/office/office2000/proddocs/opg/part2/ch06.mspx

 

[Firery]

Thankyou REMOU

Works perfectly

I hope my knowledge attains a level where I can help others too.