Need help on work books not closing and data not copying and pasting over correctly

Hi there,
i am still teaching my self a lot of this but i am (very slowly) getting there.

I have a few issues with my code.

essentialy what the code does is,
the user opens a file called "ae4", this file and its location is used to open all the necessary files.

Data is copied and pasted from the newely opened files and all these files are then to close and the data is to copy into a main file that looks after the data.

however 2 of the workbooks dont close even though my code asks them to and one piece of data that i find by first searching for a blank cell, then using offset to find the data next to the blank cell doesnt seem to copy over correctly, it carries some weird sum with it causing a circular issue.


you can read in the comments in my code where the errors seem to happen.

all help appreciated.

Please Login or Register  to view this content.

thanks again lads
Dave

Dave

Why are you opening 4 workbooks right at the start?

Why not open them one at a time, do what needs to done, eg copying etc, and then close them?

When you do open them create a reference to them which you can use on the code and when you want to close them.

Dave

This is kind of what I mean.

Please Login or Register  to view this content.