Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel not detecting that a file is currently being edited | Excel Discussion (Misc queries) | |||
Unable to create any link/hyperlinks in a particular excel file | Excel Discussion (Misc queries) | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Excel 2003 Opens Up Every File in My Documents | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |