Hi,
I have a problem when trying to close Excel. When I use MS Excel VBO::Close Instance, the Excel would close, but process in Task Manager is still seen running. The same goes when using MS Excel VBO::Close All Instances.
Process:
- Export table from 3rd party program. Program opens MS Excel (creating one process in Task Manager).
- Using MS Excel VBO::Attach to attach to opened Excel (I would love to use Attach to Workbook, but part of the Workbook's name is changing randomly whenever opened).
- Using MS Excel VBO::Get Worksheet As Collection to read the table.
- Using MS ExcelVBO::Close Instance to close Workbook and Excel at once (no need to save it).
Problem:
After using Close Instance, the Excel is closed but I can still see the process running in Task Manager. I can kill it with Kill Process, but next time I open the Excel it is in some kind of recovery mode letting you know that the Excel was not properly closed and there some backup Workbook saved if needed. I also tried Close All Instances, but this doesn't work either.
If the instance is not closed properly, next time I try to export data this way, I am not able to attach since there is more than one instance running in background.
Any idea why the action is not working? Maybe some workaround? Help! Please
I have a problem when trying to close Excel. When I use MS Excel VBO::Close Instance, the Excel would close, but process in Task Manager is still seen running. The same goes when using MS Excel VBO::Close All Instances.
Process:
- Export table from 3rd party program. Program opens MS Excel (creating one process in Task Manager).
- Using MS Excel VBO::Attach to attach to opened Excel (I would love to use Attach to Workbook, but part of the Workbook's name is changing randomly whenever opened).
- Using MS Excel VBO::Get Worksheet As Collection to read the table.
- Using MS ExcelVBO::Close Instance to close Workbook and Excel at once (no need to save it).
Problem:
After using Close Instance, the Excel is closed but I can still see the process running in Task Manager. I can kill it with Kill Process, but next time I open the Excel it is in some kind of recovery mode letting you know that the Excel was not properly closed and there some backup Workbook saved if needed. I also tried Close All Instances, but this doesn't work either.
If the instance is not closed properly, next time I try to export data this way, I am not able to attach since there is more than one instance running in background.
Any idea why the action is not working? Maybe some workaround? Help! Please