ExcelChampion
Well-known Member
- Joined
- Aug 12, 2005
- Messages
- 976
I have a macro that creates an instance of Excel, does some stuff and then ends, leaving the workbook open and visible. If I then manually close workbook, the instance of Excel still remains running in the background. I had Dim'd the instance of Excel locally originally, and no instances of Excel remained open. But, I had to make the instance of Excel Public, and that's when the issue started.
At the end of the macro, I use: xlApp.Quit, where xlApp is the public instance of Excel.
Anyone run across this and have a solution?
Thanks.
At the end of the macro, I use: xlApp.Quit, where xlApp is the public instance of Excel.
Anyone run across this and have a solution?
Thanks.