yes, basical, make a text file named as rename.bat and put under c:\test, then under ms_dos,

c:
cd c:\test
rename

put this in a dos batch file and run it

@ECHO OFF
SETLOCAL enabledelayedexpansion
FOR /l %%i IN (1,1,1000) DO (
        SET newname=000%%i
        SET newname=!newname:~-4!
        IF EXIST a!newname!.xls (
                ECHO REN a!newname!.xls b!newname!.xls
                REN a!newname!.xls b!newname!.xls
        )
)

Sir :
Can you tell in detail about : " put this in a dos batch file"
means to  open windword 2010 program  then creat a new macro ?
I really don't underrtsnd what is your means?
Sincerly !

open a notepad, copy them into the notepad, save the notepad into a file named, say, rename.bat, under the folder you have your excel files, and then open a dos command, change to that folder, enter "rename" and hit enter to execute the command.

You meams is cut rename.bat paste into my excel directlory :C:\test\..xls,
then under MS_DOS (c:\) keyin rename to excute