macro to add new sheet to many excel files from a master file

**ldsone** · 07-10-2013, 12:54 PM

I have little experience with macros in excel and I would like to ask if such thing is possible to achieve:
I have many folders (around 500) - each of them contains a excel file (the excel files have all the same name), ideally I would like to be able to run a macro from a master excel file that would allow me to add a sheet which I would create in the master excel file and add it to all of the excel files that are in the folders.
So far I have used the code from the link: http://stackoverflow.com/questions/6...using-vba?lq=1

Please Login or Register  to view this content.

but now when I am trying to run the code I will get Run-time error '9', Subscript out of range at a line:

Please Login or Register  to view this content.

but when I change it from 2.xlsx to 1.xslx in the code it works just fine, copying the sheets from the file to itself.
As I said, I have little experience with excel macros and any kind of help would be really appreciated.
Thanks.