In vba it is possible to look for keywords in files in a certain directory.
The problem I have is that the keyword thing only looks for mso file types.
If I want to search for a picture by using a keyword it just doesn't work.
Anyone an idea.

Another way is to invoke the windows explorer by using a run or shell. But
how do I tell to search in certain directory and with a keyword.

Help needed for a sleepless mind.

Re: reading file properties / keywords by XML

XML
Tue Oct 17 09:02:57 CDT 2006

vba? well in vbs you can certainly parse all files in a certain directory
line by line an use Instr() to search for certain words or phrases.
probably not very efficient if you have a lot of large files, but it would
work



"Charlie" <eurolaw101@hotmail.com> wrote in message
news:uOLz98W8GHA.788@TK2MSFTNGP05.phx.gbl...
> In vba it is possible to look for keywords in files in a certain
> directory. The problem I have is that the keyword thing only looks for mso
> file types. If I want to search for a picture by using a keyword it just
> doesn't work. Anyone an idea.
>
> Another way is to invoke the windows explorer by using a run or shell. But
> how do I tell to search in certain directory and with a keyword.
>
> Help needed for a sleepless mind.
>



Re: reading file properties / keywords by Charlie

Charlie
Tue Oct 17 13:30:17 CDT 2006

Found a way to browse to all the headers of a file (+/- 41) to look for
specific information about a file (in vba).
Some are usefull (name of file, title, category, ...) but no keyword search.
I will use category or subject or something that is readable by using my
solution.

"Charlie" <eurolaw101@hotmail.com> schreef in bericht
news:uOLz98W8GHA.788@TK2MSFTNGP05.phx.gbl...
> In vba it is possible to look for keywords in files in a certain
> directory. The problem I have is that the keyword thing only looks for mso
> file types. If I want to search for a picture by using a keyword it just
> doesn't work. Anyone an idea.
>
> Another way is to invoke the windows explorer by using a run or shell. But
> how do I tell to search in certain directory and with a keyword.
>
> Help needed for a sleepless mind.
>



Re: reading file properties / keywords by XML

XML
Wed Oct 18 08:49:47 CDT 2006

in what application are you writing your vba code?



"Charlie" <eurolaw101@hotmail.com> wrote in message
news:O97ufoh8GHA.1248@TK2MSFTNGP03.phx.gbl...
> Found a way to browse to all the headers of a file (+/- 41) to look for
> specific information about a file (in vba).
> Some are usefull (name of file, title, category, ...) but no keyword
> search. I will use category or subject or something that is readable by
> using my solution.
>
> "Charlie" <eurolaw101@hotmail.com> schreef in bericht
> news:uOLz98W8GHA.788@TK2MSFTNGP05.phx.gbl...
>> In vba it is possible to look for keywords in files in a certain
>> directory. The problem I have is that the keyword thing only looks for
>> mso file types. If I want to search for a picture by using a keyword it
>> just doesn't work. Anyone an idea.
>>
>> Another way is to invoke the windows explorer by using a run or shell.
>> But how do I tell to search in certain directory and with a keyword.
>>
>> Help needed for a sleepless mind.
>>
>
>