Rename the first Sheet Name of 130 closed excel files

**ZarrinPour** · 04-11-2009, 02:00 PM

Hi all
I have 130 excel files and for some reasons i have to rename the First and second sheet name of each file to another name (for example A1 and A2) , could any one help me please?

Kind Regards.

**ravishankar** · 04-12-2009, 01:30 PM

Hi
The macro opens each file, changes the name of 2 sheets, saves it and closes it. save the attached file in a folder and try this macro on a small set of files. If you are happy with the way it works, you can apply it to larger sets
Ravi

**ZarrinPour** · 04-17-2009, 03:43 AM

Originally Posted by ravishankar

Hi
The macro opens each file, changes the name of 2 sheets, saves it and closes it. save the attached file in a folder and try this macro on a small set of files. If you are happy with the way it works, you can apply it to larger sets
Ravi

Hi ravishankar
I lack the word with which to express my thanks.