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