General information
Category:
COM/DCOM and OLE Automation
I've tried the constants. I get the OLE "type mismatch" error.
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only