Rename the sequential excel files

Hi :
My question: I have many excel files on c:\temp\A0001.xls…..A1000.xls
I want to use Excel to rename A0001.xls…..A1000.xls to B0001.xls…..B1000.xls
ie. (rename B0001.xls= A0001.xls ….. B1000.xls=A1000.xls)
Thanks !

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

谢谢您诚心的帮助 !
Have a good time !

no problem, thanks!