Hi!

I have a data gathering programme that when I click the csv button it
creates the data in a csv file and opens it (always R.CSV) in a second
instance of excel.
In my first instance of excel I have some code that extracts the data from
the csv file and formats it differently. At present I have to close the
second instance of excel manually then by code I open in the first instance,
retrieve the data, close it and kill it, ready for the next lot of data.

The problem is if anyone forgets to close the second instance of excel I
cannot kill it.

What I would ideally like to do is in the first instance of excel, test if
there is a second instance running and if so close it. Is this possible?

TIA
Neil