VBA Loop not pasting in teh correct location

Hi

I have this bit of code which does multiple things, it opens a two files and pastes data from one to other and then adds th values to a sheet in that workbook. It then should loop through a folder and copy the data range A2:M14 and paste it into the template workbook on the identified sheet in the cell B2 and then close the file and open the next and paste the data range under the data there but also leaving a white line between them.

However currently it wont loop as it pulls an error at the highlighted line below and also does not copy and paste the correct data.

Please Login or Register  to view this content.

Can anyone work out why it is not running?

Thanks

Jeskit

jeskit,

Here's the section of your code that loops:

Please Login or Register  to view this content.

It looks like you want to loop through all the files in a directory until there aren't anymore files. Here's the code for how to do that:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar

Hi

Thank you for replying but i need it not only loop through the folder but i need to open the files that match strFile variable and copy the range A2:M14 and paste it into the template workbook in the settings sheet in B2 but when it goes the next file i need to paste it under the data there but leaving a blank line between them.

Currently i cant get it to copy the right data and paste into the right location. If you have any ideas it would be extremely helpful

Thanks

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

YOUR TITLE SHOULD GIVE AN INDICATION OF THE PROBLEM< NOT A VAGUE REFERENCE TO LOOPS