Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement