[文本处理] 批处理怎样找到文件夹里时间靠前的文件，用EXCEL打开该文件？

@echo off
for /f "tokens=1-3* delims= " %%a in ('dir/tw/s/a-d *.*^|sort /r') do (
set file=%%~dpnxd
    if exist "%%~dpnxd" (
       set /a m+=1
       setlocal enabledelayedexpansion
      if !m! leq 1 (start notepad "!file!"&echo.%%d&endlocal) else endlocal
))
pause
复制代码

@echo off
for /f "tokens=1-3* delims= " %%a in ('dir/tw/s/a-d *.*^|sort /r') do (
set file=%%~dpnxd
    if exist "%%~dpnxd" (
       set /a m+=1
       setlocal enabledelayedexpansion
      if !m! leq 1 (
type "!file!" | clip 
echo.%%d&endlocal) else endlocal
))
pause
复制代码

@echo off
set "FolderName=D:\output"
cd /d "%FolderName%"
for /f "delims=" %%i in ('dir /b /a-d /od *.txt') do (
    set "LastFile=%%i"
)
start Excel "%LastFile%"
复制代码