Jul 14 2022 12:52 AM - edited Jul 15 2022 01:27 AM
UPDATE: Thanks to @Jagodragon which provide a way to kill all the processes created by QueryTable method. However, it would be great if I can know why these processes are generated; Also, if killing all the processes is the only solution, is it safe to kill all of them?
Question: Hello, I am using QueryTable to import csv files in VBA macro.
My Macro delete all connections and Querytables after importing the csv files.
However, even if I close the workbook that contains the macro I used, as long as I left other excel workbooks open, the Console Window Host and the Mashup Container keep existing.
How can I properly delete all the console window host??
Thanks in advance.
.
Jul 14 2022 07:03 AM
Solution
you can try using this in your VBA code
Shell "taskkill.exe /f /t /im Microsoft.Mashup.Container.Loader.exe"
it should kill all the instances of the process "Microsoft.Mashup.Container.Loader.exe"
This is not my code. I just knew i'd seen it before and did a google search.
Good luck.
Jul 14 2022 09:10 AM
Jul 15 2022 08:14 AM
Jul 14 2022 07:03 AM
Solution
you can try using this in your VBA code
Shell "taskkill.exe /f /t /im Microsoft.Mashup.Container.Loader.exe"
it should kill all the instances of the process "Microsoft.Mashup.Container.Loader.exe"
This is not my code. I just knew i'd seen it before and did a google search.
Good luck.