.
Hello Tommy,
I like Ollie's method of having the Excel file close itself after it has done its work. However, if you have to close it from Lookout, here's another, less graceful, approach...
Use the Run object and the attached kill.exe (originally from Microsoft) with the following command:
kill /f excel.exe
Of course you'll have to get the syntax right for the Run object and provide the path to the Kill.exe. This just zaps Excel to death! You'll lose all unsaved data, etc. The switch "/f" is to force this, and is required.
As they say, "if brute force isn't working, you're not using enough of it!"
Hope this helps,
Khalid 🙂
.