Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Nadia
 
Posts: n/a
Default dump file search results into excel

Is it possible (or is there an application available) that allows results
from a file search in explorer (which will return thousands of documents) to
be dumped into an excel spreadsheet so filters can be applied and the search
results manipulated further????

cheers,
Nadia
  #2   Report Post  
Bryan Hessey
 
Posts: n/a
Default


I don't think Search intends you to save the results, the saved file
from a search is the search criteria.

If you run a CMD window (Start, Programs, Accessories, Command Prompt -
or DOS window) you can type:

C:
CD \
dir /-n /b /s *.tif list_tif.txt

which will list all of your .tif files into a file list_tif.txt, you
can then open this in Excel and maniplulatre your results.

Of course, you can modify the instructions to better suit your search
purpose.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390847

  #3   Report Post  
Nadia
 
Posts: n/a
Default

Thank you very much Bryan. Im sure this will help.

cheers,
Nadia

"Bryan Hessey" wrote:


I don't think Search intends you to save the results, the saved file
from a search is the search criteria.

If you run a CMD window (Start, Programs, Accessories, Command Prompt -
or DOS window) you can type:

C:
CD \
dir /-n /b /s *.tif list_tif.txt

which will list all of your .tif files into a file list_tif.txt, you
can then open this in Excel and maniplulatre your results.

Of course, you can modify the instructions to better suit your search
purpose.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390847


Reply
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
Excel not detecting that a file is currently being edited cds_tech Excel Discussion (Misc queries) 1 June 27th 05 09:06 PM
Unable to create any link/hyperlinks in a particular excel file Nabanita Excel Discussion (Misc queries) 0 June 21st 05 11:52 AM
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
Excel 2003 Opens Up Every File in My Documents Glenn Reschke Excel Discussion (Misc queries) 4 February 11th 05 06:00 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM


All times are GMT +1. The time now is 08:35 AM.

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

About Us

"It's about Microsoft Excel"