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
Does anyone know how to do this as i am not sure??![]()
Please Login or Register to view this content.
Thank you
Jeskit
Bookmarks