Search directory and path location of Windows files using “where” command.
Where is a command line tool. Since it's a command line tool it can be automated using a batch file or any scripting of your choice.
Here’s an example of where command:
where /R c:\users\username *.doc *.xls
Command above will find all document files and excel files in folders and subfolders of c:\users\username. /R is an option to search recursively.
The above command just use a space as a delimiter to set a parameter for other files to include on the search.
The complete path and file name for all files matching will be displayed.
But it’s better to specify a specific path; the more folders to search recursively then the longer it takes to find the matching files.
where /R c:\users\ My*.doc
Command above will search for documents a file that begins with “My” on its filename. The path is on C:\users, if the user is executing has proper right to access the folder of other users. Then the output will include the files of other users.
From Windows help the parameter of list is:
/R Recursively searches and displays the files that match the
given pattern starting from the specified directory.
/Q Returns only the exit code, without displaying the list
of matched files. (Quiet mode)
/F Displays the matched filename in double quotes.
/T Displays the file size, last modified date and time for all
Cheers.. Till next time..
Excel Keyboard shortcuts guide