Rename Sheet name for all the excel files within the folder

[pitamine]

Hi,

Need some help with the macro on this subject.


I have a folder with multiple xls and xlsx files in it. All the files have various sheet name starting with number 2. Let say i've sheet name 20001, 20002, 20003 and so on to change to new name "bbb"..


Please let know if there an efficient way of doing this..


I am looking at alternate modes of accomplishing this and will keep posted .


Thanks in advance. Tq.

[davesexcel]

Hello,
Did you want the new names to be "bbb1","bbb2","bbb3"

[pitamine]

no, i want it to be "bbb". same for all file

[davesexcel]

Will there be only one sheet in each workbook?