Posted to microsoft.public.excel.programming

Robert Crandal[_2_] Robert Crandal[_2_] is offline

external usenet poster

Posts: 158

Searching a group of Excel workbooks.....

I have about 100 or so workbooks that are contained in the
same folder. Rather than manually opening each file to search
for a particular piece of data, what is a quicker and more
efficient way to do this???

Would I need a VBA script that opens and closes each file,
one after the other and then do my search in each workbook??

Thank you!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Searching across multiple workbooks in Excel 2003	jrpfinch	Excel Programming	0	November 4th 09 04:44 PM
Searching Multiple Excel Workbooks	G.Simpson	Excel Discussion (Misc queries)	3	December 21st 06 04:09 PM
Searching Multiple Workbooks	ClarisOLeary via OfficeKB.com	Excel Discussion (Misc queries)	2	October 12th 06 05:01 PM
Searching Across 2 workbooks	HelpDeskTech	New Users to Excel	1	May 16th 06 09:51 PM
Searching multiple workbooks	phreshjive	Excel Discussion (Misc queries)	2	January 26th 06 06:56 PM

All times are GMT +1. The time now is 03:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us