11-07-2023
12:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
11-07-2023
12:29 PM
If you start new instance of Excel using CreateObject("Excel.Application"), you are responsible for closing them. You can't only set excelApp = Nothing you must exactly exit the application using excelApp.Quit(). If you call GetObject("Excel.Application") later, it is not guarantied you obtain exactly the same instance of Excel. You get one of Excel objects from RunningObjectTable.
I recommend you to close Excel when you finish your task. Don't keep them open. Or try to get existing (running) Excel application instead of create new one. At least close all files and free them for another processes.