LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Search formula referencing range of keywords Malvaro Excel Worksheet Functions 5 July 7th 08 03:47 PM
How do I search for keywords in cells containing text? Fredrik Excel Worksheet Functions 4 June 28th 07 01:56 PM
Need Help!! Want to search through 3 columns for a list of keywords The Moose Excel Worksheet Functions 7 January 2nd 07 03:12 AM
Keyword search, several keywords Doman Excel Discussion (Misc queries) 1 July 24th 06 10:58 AM
can i make a formula to search keywords in a excel workbook? gorillayam Excel Worksheet Functions 0 January 15th 05 02:25 AM


All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"