Batch file to open the most recent excel file

[rajasekhar28]

@echo off
for /f "delims=" %%x in ('dir /od /a-d /b *.xls') do set recent=%%x
start "" "C:\Program Files\Microsoft Office\Office11\excel.exe" "%recent%"

i'm using the above code, trying to open the most recent excel file in a folder but for some reason its only opening the a new excel file (new workbook) and not the most recent file in the folder. i'm running this batch file in the same folder where i have all the excel files.

any ideas??

Thanks

[solnajeff]

Hi

I cannot help you directly but if you check this link,

you will find code to open the most recent file in a folder. You could add the code to a personal.xls file and add a toolbar and button to open the file from excel.

Regards

Jeff

[alonso]

Sorry I don't know about it. If any one can help then mine also. Thanks In advance.