Try not closing the workbooks before using it.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"andycharger " wrote in message
...
Hi,
I am using ActiveWorkbook.Close to close my spreadsheets but I would
also like to terminate Excel too.
I have tried Application.Quit but this did nothing and Excel was still
open.
Does anyone know of a way to close Excel from a macro and can they
provide and example?
Thanks
---
Message posted from http://www.ExcelForum.com/