VBA loop using two arrays

Hi

This is probably a very easy question to solve but i need to create a loop which loops through two arrays. The loop should first loop through an array of path name variables to open the files (and if the files arn't there more to the next one)

Then it should copy data from the file opened and paste it into another workbook using a second array for the sheet name.

I am sorry if i have not explained that very well.

I have created the following loop, however i get a type mismatch
error

Please Login or Register  to view this content.

Does anyone know how to do this as i am not sure??

Thank you

Jeskit

hi, jeskit, you nearly have everything done but there are some things to correct:
1. If Option base 1 is absent before Sub line your PathArray will start from zero not one, so it should be:

Please Login or Register  to view this content.

Same goes for SheetArray.
2. The workbook with each path will be opened once so this "workbook-opening" line should be in first loop:

Please Login or Register  to view this content.

3. To access value in for example PathArray here you need to use this:

Please Login or Register  to view this content.

So PathArray(X) when X=0 gives you value "Path1"
Same goes for SheetArray.

Hi

Thanks for replying!

I have made th changes you suggested but it stills produces a type mismatch error on the line For Y = 1.

Please Login or Register  to view this content.

p.s. Option Base 1 is now not absent from above the sub-line