Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 04-22-2011, 08:24 AM
mar999 mar999 is offline effective searching Windows XP effective searching Office 2007
effective searching
Join Date: Apr 2011
Posts: 1
mar999 is on a distinguished road
Default effective searching

I need to find how many instances of a certain phrase occurs in a set of excel files in a directory. (for example, looking for the word "sample" where there might be 3 instances in one .xls file, and 7 in another..) I can't seem to find the right filters in the explorer window.
Reply With Quote
Old 05-04-2011, 04:51 AM
OTPM OTPM is offline effective searching Windows 7 32bit effective searching Office 2010 32bit
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road

You won't find the right filters as what you are trying to do in explorer is not possible. All it will do is display the files containg the words or phrases you are looking for. It will not count the number of instances in each file. You would probably have to write a macro to do this.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Business Contact Manager 2010 Searching Problem admsvcs Misc 0 03-05-2011 04:29 PM
effective searching Searching in Outlook 2007 Contacts appears to be stuck danhogan Outlook 2 09-20-2010 07:55 AM
effective searching Searching dates to create lists brianh Excel 2 01-18-2010 01:58 PM
Searching Outlook folders not working cltaylor Outlook 0 08-31-2009 10:28 AM
effective searching Searching another persons contacts Hendo313 Outlook 1 07-10-2009 09:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:08 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd. is not affiliated with Microsoft