Printable View
oXL.Quit
Set oXL = Nothing
Should do the trick. Are you sure you are opening only one instance of Excel? Sometimes people have both:
Set oXL = New Excel.Application
set oXL = CreateObject("Excel.Application")
or something similar and they actually open two instances of Excel. Make sure you only use one. You might want to post your code so we can look at it.
This is the bit of code that I use to open the book I need??
Is this correct???
Set oExcelApp = CreateObject("EXCEL.APPLICATION")
Set oWs = oExcelApp.ActiveSheet
Set MyBook = Workbooks.Open(FileName:="c:\Book1.XLS")
Try this:
Dim oExcelApp As Excel.Application
Set oExcelApp = CreateObject("EXCEL.APPLICATION")
oExcelApp.Workbooks.Open ("c:\Book1.XLS")
oExcelApp.ActiveWorkbook. do whatever
oExcelApp.Workbooks.Close
oExcelApp.Quit
Set oExcelApp = Nothing
You have to reference your workbooks and worksheets within the oExcelApp. In the new way of doing Office automation, you don't have separate stand-alone objects for each worksheet or workbook. They are all gotten to through the oExcelApp object.
By the way, I have tested this code and it deletes the Excel process.
Cheers HDR worked a treat. Must be where we were trying to open an application and then a workbook as seperate objects!
this has also solved the problem we had with saving the book a number of contiguous times!
Thanks