View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Search Excel files for text and keywords?

I am using Office 2003 on Windows XP.

You can MANUALLY search closed Excel files and determine which ones contain
certain text and/or key words. This can be performed from Windows Explorer,
but also from inside Excel, through the "File-Open" dialog box. Click Tools
then Search. This is a useful tool to help identify or pinpoint specific
files.

The macro recorder does not capture these keystrokes.

QUESTION: Is it possible to perform such a search programmatically? If so,
could someone please post example code?

Thanks much in advance for your assistance.