Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How to search files from withing excel?

17 May 2015   #1

Windows 7 x64
How to search files from withing excel?

I have a list in excel of character strings (e.g. BAL674). I would like to search a folder and its subfolders on my hard drive for files with names that contain my stings. For each string I would like to get all (none, one or more) file names. Any ideas if this is possible and how to do it?

My System SpecsSystem Spec
21 May 2015   #2

Windows 10 x64

I would use FileSearchEX for this. Do a search for "*.xls" (or whatever your file extension is) and then for the "Containing Text" part enter the string you're looking for.
My System SpecsSystem Spec

 How to search files from withing excel?

Thread Tools

Similar help and support threads
Thread Forum
Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2
The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb. I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit. The W700 has Office 2007 and theW541 has Office 2013. Both versions ofExcel are 32 bit as far as I...
Microsoft Office
Automate Visio file(s) search via Excel or Explorer
New to the forum, and hoping that there already exists a solution to my problem, or that the community gurus can help... I was tasked at work with creating several new pages (multiple files) of Visio schematics. I have an Excel spreadsheet that lists the major components as a sort of Bill Of...
General Discussion
Windows 7 search for files&folders...can i make it search like XP?
I asked this when i first got 7 about 1.5 years ago, but i never found a good replacement to make 7's file search anywhere near as good or similar as the XP search. Now 1.5 year later, is there anything like that?
General Discussion
Windows 7 search files and folders vs Outlook 2007 search
Hello, Can someone tell me some specifics and pinpoint the differences (or maybe a good website) that would pinpoint the differences between the Windows 7 search and the outlook 2007 search? I know the outlook search searches through email but are there other difference I am overlooking between...
General Discussion
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 22:33.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App