Visual Basic help

[The Boosh!]

Hello!

Bit of help please.

I have a folder on my desktop which has thousands of xls files in it. All have 1 sheet.

Is there any vba code I can use to find a specific value in all these spreadsheet?

I.e I want to find luke123 in one of these thousand spreadsheets.

Basically a ctrl + f but for lots of sheets instead of one.

Long shot but worth a try.

Cheers

 

[z8jay]

Try this

http://www.icetear.com/en/menu/

 

[@Spoonie]

Is this a one off? If so, just index them with the builtin indexing service. You could even the use vb to query the catalog. On my phone at moment so can't get you examples.

 

[ChrisR]

Can you get grep on windows? That'll do it with the -r switch.

 

[jenic]

Does this help?

http://www.icetear.com/en/menu/

 

[Gray]

Tried this?

http://www.icetear.com/en/menu/

 

[Addicted]

If the above fail, try this

http://www.icetear.com/en/menu/

 

[The Boosh!]

Im doing it for work and can't install any external programmes. I'm fairly competent with VBA but I've not looked at it for a bit, so just wanted some basic code.

 

[jenic]

Icetear I liked to doesn't need to be installed, just download it and run it

 

[Chapster5]

If you still havent got it, try this

http://www.icetear.com/en/menu/

Might help

 

[@Spoonie]

If it were me doing this I would be looking to index the files with either Indexing Server or Search for fast queries (assuming you are running Windows) then its simple to create COM objects to query the catalog:

http://msdn.microsoft.com/en-us/library/bb286799(v=vs.85)

http://msdn.microsoft.com/en-us/library/ms692219(v=vs.85).aspx

 

[iain187]

doesnt the windows search companion have 'a word or phrase contained in the file' ???