EXCEL.exe running in background after routine has completed....

[Hyflex]

Hi Guys,

I have a massive chain of macros spread over 5 modules and

Module 1 = Opens up a userform, then calls module 2s chain of macros, then calls module 3's chain of macros and then finally module 4's chain.
Module 2 = Opens 10 documents, Imports the data, Closes the documents, manipulates the data inside the original sheet.
Module 3 = Uses the imported data and manipulates it more, opens up a database file, imports more data, closes the document, uses a bunch of formulas, maniplates more, opens up a new document pulls in more data and maniplates more.
Module 4 = Uses the userform from the start and saves the file into several parts, opens up a sheet throws the data into that sheet and then saves that sheet several times..
Module 5 = Contains some simple functions that are called by module 2, 3 and 4

The computer is using Office 2010 and I can't post the document in question because it contains too much confidential data/code :/

I can't figure out why there are a bunch of stuck/frozen/hung excel.exe processes.

I thought as soon as a sub ends it forgets all of the values that were in the memory / locals?, the only global variables I have are a bunch of true/false variables...

Any idea how I can solve this without having to put

Dim sKillExcel As String

sKillExcel = "TASKKILL /F /IM Excel.exe"
Shell sKillExcel, vbHide

Any help would be appreciated.

[Norie]

At any point do you create a new instance of Excel in this lengthy process?

Also, at any point could it be possible that a document that's been opened isn't being closed once its been dealt with?

Finally, are you using a fair bit of On Error.. in the code?

[Hyflex]

I'm using the following at one bit:

I have 10 of the following:

Workbooks.Open Filename:="" & RAWDATALOCATION & "\main.xlsx"

Windows("main.xlsx").Close SaveChanges:=False

I have 1 of the following, next two code examples use this same file so it only closes later on

    Dim wbList As Workbook:     Set wbList = ActiveWorkbook
    Dim wbData As Workbook:    Set wbData = Workbooks.Open(Filename:="C:\file.xlsm")

    Set wbList = Nothing
    Set wbData = Nothing

I have 6 of the following

    Dim wbDest As Workbook:     Set wbDest = ActiveWorkbook
    Set wbSource = Workbooks("file.xlsm")

    Set wbSource = Nothing
    Set wbDest = Nothing

I have 1 of the following (it closes the file from above that stays open through 5 macros)

    Dim wbDest As Workbook:     Set wbDest = ActiveWorkbook
    Set wbSource = Workbooks("file.xlsm")
    wbSource.Close SaveChanges:=False
    
    Set wbSource = Nothing
    Set wbDest = Nothing

I have 1 of the following:

Workbooks.Open Filename:="C:\output.xlsm"
Windows("output.xlsm").Close SaveChanges:=False

I have loads of the following:

    Set wsDest = Sheets("sheet1")
    Set wsSource = Sheets("sheet2")

Do I need to set all of them to nothing???

At the very end of my code I use:

    Application.Quit

Is this where the problem is? If I use the close function it leaves excel up with no documents opened.

[Hyflex]

Bump, Could still really do some help with this.

[watersev]

hi Hyflex, it looks it has nothing to do with VBA, this is an opposite question but I think it should help you to restore expected behaviour beyond coding: http://answers.microsoft.com/en-us/o...9-c23a0e3a314b