Thank you everyone! This works!
>Try this
>
>
#DEFINE xlValues -4163
>
>>Hi all,
>>
>>I have over 5000 Excel documents that I need to rip data out of, but I can't seem to figure out how to tell the "find" command in Excel to not search the formulas, but the values only. Here is what I am trying.
>>
>>oExcel.Range('A1').Find("Street",,,,,,,,TRANSFORM(4294963133, "@0")).Select
>>
>>The transform command is what I've tried to use to get the hex value of the xlValues constant. Which I've also tried this way.
>>
>>#define xlValues 0xffffefbd
>>
>>And then using the xlValues, like this.
>>
>>oExcel.Range('A1').Find("Street",,,,,,,,xlValues).Select
>>
>>Which doesn't seem to work either.
>>
>>Any other suggestions?
>>
>>TIA