Case sensitive searching

I'm trying to program a search that is not case sensitive in VB. I am searching RTF, Word & Excel files. Does anyone know how to do this? Thanks!

hi,
put this in your declarations:

Code:

---

Option Compare Text

---

Hope this helps

Shaun

Option Explicit
Option Text Compare

or is it
Option Compare Text

Thanks for the input it was very helpful!!!:)