VBA Module(Access) exe32-not-closing-in-task-manager

[orchid67]

What's wrong with this function? excel is not closing in task manager.

Function formatExcel()
    Dim FileName As String
    FileName = "C:\This file\queryCentering.xlsx"
    Set xl = New Excel.Application
    Set wb = xl.Workbooks.Open(FileName)
    With wb.Sheets(1)
        Columns("E:E").Select
        Selection.NumberFormat = "m/d/yyyy"        
 
        Columns("C:C").HorizontalAlignment = xlCenter
 
    End With
    wb.Save
    wb.Close True
    Set wb = Nothing
    Set xl = Nothing
    xl.Quit
   End Function

[PhilOfWalton]

I think you are ding things in the wrong order

Try

    XL.Application.Quit           ' When you finish, use the Quit method to close
    Set XL = Nothing  
 

Phil

[ADezii]

Like Phil has already said, it's all in the order. You are releasing all Resources assigned to an Object Variable representing an Instance of the Excel Application, then in the very next step trying to execute the Quit Method of this very Object. The only problem is that the Object no longer exists. I am very surprised that you did not receive the following Error:

Run-time Error 91
Object Variable or With block variable not set