Forum Discussion
Solved
Use Querytable in VBA, process exists even after delete all connections and querytable.
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 killin...
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.
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.
- Thanks! This really works.
However, I believe that it will also delete other Processes which are not created by the macro I had run. (For example, other macros also utilize QueryTable and left something like this.)
Is there any possible way to fetch the PIDs and kill those processed more specifically?
I am using `ActiveSheet.ListObjects.Add` method- I do not believe that it is possible to filter the PID get process results in a way that would allow you to strip the correct PID from the correct process.
perhaps some one with more experience can help with this. but i do not think it is possible.
