The first thing I would do is to make sure that the correct reference
libraries are loaded.

When ever I run into hanging issues, I always pepper the code with message
boxes so I can track where I am at any given point. You should also try to
step-through the code to see where it hangs.

If you can, post the code. Someone may spot something.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"RobcPettit" wrote:

Hi, with 2003 I had a workbook that, using vba, would open another
workbook, copy details from a certain worksheet and paste back into
first workbook, which using vba goes on to carry out tasks.. This all
worked fine. With 2007 the same procedure locks up excel. Ive tried
doing this manually. This is the outcome. If I open the book I want to
copy from and open a new workbook, copy and paste details into new
workbook works fine(with out vba). If I try to copy into my original
workbook (which contains vba modules), excel hangs. Any ideas.
Regards Robert