Hello:

I am using Excel 2013.
But the file "1-22-14_SF0003_TC_RPT.xls" is Microsoft Excel 97-2003 Worksheet file.
I will have quite a few files every day and would need to rearrange the Clockin-out data and save as MS Excel 97-2003 Worksheet file to work further with other applications.
That's why i will be using above code to rearrange but stuck at automatically saving the file in MS Excel 97-2003 worksheet format.
Please help.

Thanks a lot

Riz