Copying from one Workbook to another not working

Hi

I'm trying to copy a range of data from one workbook, open another workbook, check that no one else already has it open and if not paste the data at the end of the existing data. I then would like to save & close the file and delete a few sheets from the original workbook.

When I step through the macro it opens the file then jumps back to the start of the macro without pasting or closing the newly opened workbook.

Any suggestions would be greatly appreciated.

Please Login or Register  to view this content.

Thanks Jo

Thanks so much Robert, that worked a treat! The only change I made was to swap the Destination method to the Paste method so that I could paste special values as there were a couple of formulas in the copied range.
Cheers
Jo