In Excel VBA 2010: How to destroy excel vba.application object

Question

I have an Excel.Application object which seems to live on as a Windows Process AFTER my VBA code has executed and Excel 2010 is completely closed out. i.e. Windows Task Manager shows the Process as "EXCEL.EXE *32", even after I've closed Excel.

Here's some code below :

Public Sub Test Dim xls As Object

Set xls = CreateObject("Excel.Application")
Set wb = xls.Workbooks.Add

fullFilePath = importFolderPath & "\" & "A1"
wb.SaveAs fullFilePath, AccessMode:=xlExclusive    ' SAVE WORKBOOK AND CLOSE !
wb.Close (True)

' question: How can I destroy the xls object ????

end sub

Basically I can't figure out how to destroy the "xls" I've created in my code. And as I've stated above, it causes EXCEL.EXE *32 to live on as a windows process.

thanks in advance.... Bob

Mark PM · Accepted Answer · 2013-01-30 22:27:12Z

7

Use xls.Quit after you close the workbook

answered Jan 30, 2013 at 22:27

Mark PM

2,90416 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

bob.mazzo Over a year ago

Thanks ! I looked for Destroy, Exit, Close...all except the obvious QUIT. Thank you so much.

bob.mazzo Over a year ago

it's also prompting me to overwrite the prev excel file on this line of code: wb.SaveAs fullFilePath, AccessMode:=xlExclusive . I've tried to turn off alerts but this line doesn't work for this: Application.DisplayAlerts = False

Mark PM Over a year ago

Which version of Excel, just tried it with 2010 and it works for me

Collectives™ on Stack Overflow

In Excel VBA 2010: How to destroy excel vba.application object

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related