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