VBA not closing excel (visible in the task manager)

Hi All,

the following code does some simple stuff in outlook. When i run the code once, everything goes as planned.
Upon its second run, it comes up with various errors. I've looked what the difference is between the first and the next runs and it seems that excel isn't closed (its still visible in the task manager). as soon as i close it manually (task manager), i can run the code once again - but only once since excel will still end up in the task manager.

Thanks for any guidance!

Please Login or Register  to view this content.

Hi Bishonen,

I noticed two things.

1. there is no error handling which may prevent the xlApp.Quit statement from being executed
2. I am not familiar with xlApp.UserControl (frequently use the Excel app instance in memory trick - never used this method)

I would suggest to add error trapping

Please Login or Register  to view this content.

Thanks a lot for your reply. Unfortunately that still does not get rid of the excel instance ;/ I'm fighting with this problem since ~1.5h googling my way through dozens of forums and I still didn't find a solution that would work...

Originally Posted by Bishonen

Thanks a lot for your reply. Unfortunately that still does not get rid of the excel instance ;/ I'm fighting with this problem since ~1.5h googling my way through dozens of forums and I still didn't find a solution that would work...

Have you tried removing statement xlApp.UserControl=False?

Else make the xlApp visible and step through your code using debug to see where it goes wrong.