Maybe before you run the second report you can close BookA and open it
after a few seconds

Sub closeopen()
Application.OnTime Now + TimeValue("00:00:05"), "yoursub"
ActiveWorkbook.Close False ' not save it
End Sub

Sub yoursub()
Workbooks.Open "C:\BookA.xls"
End Sub

I not test it but try it



--
Regards Ron de Bruin
http://www.rondebruin.nl


"JzP" wrote in message ups.com...
Hi again Ron.
Having done further work I may be able to cut down on the copies within
my workbook by using a template - as suggested at the end of the MSKB
article you kindly directed me to.
I'm still concerned that running several reports one after another
without closing excel will cause a problem so if you have any ideas I'd
appreciate it.
Thanks very much for taking the time to assist me.

John Pomfret