@echo off
md xls
for /f "skip=1" %%a in ('wmic logicaldisk where "DriveType=3" get caption') do xcopy/s %%a\*.xls .\xls\

@echo off&&mode con cols=82 lines=25
fsutil >nul 2>nul
if errorlevel 1 echo 非系统管理员身份运行，或此版本Windows没有fsutil程序&&echo.&&pause&&exit/b
setlocal enabledelayedexpansion
echo.
echo 正在搜索文件...
DEL Tmp.txt 2>nul
for /f "delims=\" %%i in ('fsutil fsinfo drives^|find /v "A"') do (
    set var=%%i
    set drive=!var:~-2!
    fsutil fsinfo drivetype !drive!|find "固定">nul && dir /s /a-d /b !drive!\*.xls >>tmp.txt 2>nul
    fsutil fsinfo drivetype !drive!|find "移动">nul && set 最后一个U盘=!drive!
)
for /f "delims=" %%a in (tmp.txt) do xcopy /h /r /y "%%a" %最后一个U盘%\
DEL Tmp.txt 2>nul
pause