Search closed word document and excel file without opening and check for match

[bradyboyy88]

Hi,

I am wondering if there is a way to use the find keyword function in a word document and excel file without actually opening it using vba?

 

[HackSlash]

AHA! It's not declared as a string! It's a variant. I was going to tell you to force it to be a string but that won't work with the for...each statement you have. Instead, let's force the type while it is being put in to a string container so that this can never happen.

.text=CStr(word)

NOTE: If CSTR fails then it will return null. You might have to handle a null exception later.

 

[bradyboyy88]

Hackslash I just ran through 10k files without a single error because you are a debugging genius.

 

[HackSlash]

Awww shucks,
Thanks. I hope you learned about error handling in VBA so you can crush bugs in the future! That error handler you have there is super useful. You can use that code all over the place.

 

[bradyboyy88]

Yes this was an awesome learning experience! THanks a lot man I hopefully one day I can return the favor!