Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Visual Basic help

The Boosh!

ClioSport Admin
  Elise, Duster

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.

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.

The Boosh!

ClioSport Admin
  Elise, Duster
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.


ClioSport Club Member
  981 Cayman
Icetear I liked to doesn't need to be installed, just download it and run it :)