dump file search results into excel

[Nadia]

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

[Bryan Hessey]

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.

[Nadia]

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
>
>