picking up latest excel file from folder.

[noman212]

i am making attendance dashboard which display check-inn time of each employee. time of each employee is in excel sheet , sheet is placed in a folder i have use the following script to reload sheet from folder.

LOAD EMP.CODE,

     NAME,

     DESIGNATION,

     [D A T E],

     [T ME IN],

     ENT.TYPE

FROM

'\\192.168.150.225\Sharing\Attendance\*.xlsx'

(biff, embedded labels, table is [rptCUMTIMESHEETAll.rpt$], filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(equal, 'Information Systems')))

));

Excel sheet file name is 29th may,2014

my question is excel sheet from which time of each employee is loaded is placed on sharing attendance folder as mention in script and excel-file name is changed date wise for example 30th may,2014.xls, 31st may,2014.xls and so on..

i want to load only current excel file if today is 6th jun i want to reload on 6th jun,2014 for today i dont want to delete old sheets . how can i do this??

[noman212]

Jebamalai Dass