one folder & so many excel files are save, i want name change without open excel files

hi,

i have one folder and so many excel files. i want rename i.e.

sheet name: E1200_Advance settlement for Exchnage,Corporate & Loyalty_Mar 2013.xls
i want rename files name without rename click & one by one rename simple name change process i want

first five letter dealer wise code & different , but _Advance settlement for Exchnage,Corporate & Loyalty_Mar 2013.xls are same.
i want : E1200_Advance settlement for Exchnage Corporate & Loyalty_feb 2014.xls

i think this might work for you

http://www.labnol.org/software/tutor...ogl-docs/2481/