Loop in different files

[jnh0]

Helo guys,

I want to run a Loop in different files. Right now the code I have, it erase all those sheets that doesnt countain "Resp. Co" inside of a cell, but only in the file called "MorningReport.xls". I need to do the same macro but from the file "20130101" to the file "20130131". As you can see, the files contain the yearmonthday so it can be continuous, so I was thinking that maybe I can run a file name as numbers.

I tried this one but is not working:

Please Login or Register  to view this content.

Can you help me please?! thanks!!

[Norie]

Perhaps.

Please Login or Register  to view this content.

[jnh0]

It gives an error in this line:

Please Login or Register  to view this content.

Sorry, I dont know if I was quite clear in the name of the files. The files names are 20130101.xls to 20130131.xls

[Norie]

An error?

Any particular error?

If the problem is the file extension:

Please Login or Register  to view this content.

[jnh0]

No, just subscript out of range! :S

[jnh0]

Hey I found where was the error. The date

Please Login or Register  to view this content.

The 31 was in the middle instead that being at the last. I tried it that way and it worked.