>I've tried the constants. I get the OLE "type mismatch" error.
I have no idea what the problem is. It worked for me, for the constants I have used.
You must:
Download the file which has the extension .H
Use in #include command in your program, or specify an include file in a form or class. (Alternatively, #include some other file, which in turn HAS AN #include for the Excel constants.)
>
>>Search the download section, keyword "constants". You have #include files there, which define lots of constants for Excel and Word.
>>
>>>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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)