Going the other way, using Access to automate Excel, I have had Excel hang. I added a line "DoEvents" and it seems to have helped.
What was happening is that the code would close the Excel instance, but Excel was not actually quitting before the Access procedure ended, leaving the Excel process still running. I used Taskmanager to look at the processes to see if the Excel instance had closed. After adding the DoEvents line, I didn't have any more problems closing Excel.
Have taskmanager visible when you code is executing to see if the Access process ends or not.
Try adding the line in blue:
Code:
<snip>
.Quit
DoEvents
End With
Set appAccess = Nothing
My $0.02....FWIW
HTH
-----
Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)