Excel background process does not quit

[oldcitycat]

Would someone please explain why the Excel process continues to run even after Closing and Quitting.
From my limited understanding I thought sourceWB.Close & xlApp.Application.Quit would do the trick.
What Am I missing?

Private Sub UserForm_Initialize()If TimeCard.tbEmployeeID.Value = "" Then
LoadTimeCard
Else: Exit Sub
End If
End Sub

Function LoadTimeCard()Dim sourceWB As Workbook
Dim sourceWS As Worksheet
Dim xlApp As Object


Set xlApp = CreateObject("Excel.Application")


With xlApp
    .Visible = False
    .EnableEvents = False
End With


strFile = "C:\TimeCard\PCI_TimeCard.xlsm"


Set sourceWB = Workbooks.Open(strFile, , True, , , , , , , True)
Set sourceWS = Worksheets("2678")
sourceWB.Activate


TimeCard.tbEmployeeID.Value = Worksheets("2678").Range("C2")
TimeCard.tbEmployeeName.Value = Worksheets("2678").Range("C3")
TimeCard.tbDepartment.Value = Worksheets("2678").Range("C4")
TimeCard.tbPayPeriod.Value = Worksheets("2678").Range("C5")


sourceWB.Close
xlApp.Application.Quit
Set xlApp = Nothing
End Function

Thank you in advance for any and all suggestions
OldCityCat

 

[mole999]

have you started a clock somewhere?

 

[oldcitycat]

Sorry but I really don't understand your question.

Please elaborate.

 

[mole999]

if you start a timer you have to stop it implicitly, closing excel dosen't do it (unless you do a s system restart)

 

[oldcitycat]

That makes perfect sense, but to my knowledge I have not started any timers.
Do you see something in the code that indicates a timer is running?

 

[V_Malkoti]

That UserForm_Initialize function, is that in Excel workbook or some other app like Word or Access?

If it is in another Excel workbook, then that means that you have two Excel processes when running the function LoadTimeCard. After LoadTimeCard function kills process created in it, the process running the Userform function still remains.

 

[oldcitycat]

It an Outlook Userform that reading and writing to Excel.
I have verified that Excel is not running before opening the TimeCard form.
The form load correctly with the data from Excel.
When I exit the form via the X on the form then check task manager Excel is still running as a background process

 

[Fluff]

2 things to try
1) do not close the workbook first.
2) In excel options > Trust centre > Trust centre settings > Macro settings > Trust access to the VBA project

 

[oldcitycat]

Not closing workbook first - no help
Both Excel & Outlook have Trust access to the VBA project checked.

 

[oldcitycat]

I just made a discover, that If I close Outlook then Excel background process ends.
I'm wondering if it's because the form is opening it "ThisOutlookSession"

Public Sub OpenUserForm_Click()TimeCard.Show vbModal
End Sub