I have a network drive that has hundreds of folders in it, each with a few files. The one of interest is an Excel file named XX_Form_54. I would like to create a folder on the desktop and add all these Excel files to that folder using the Command Prompt on Windows.
I've already tried using
echo Starting Now xcopy "source" "destination" echo Back Home pause
All this does is copy the files in the source directory, nothing from each folder.
In other words I want all the Excel files from the subfolders to be pulled into the main directory.