Write text files, run another program, delete txt files upon alt-tab / exit..

Hello!

I tried to make the topic as clear as possible, but in trying to do so I probably made it vague..

Here is the deal. The spreadsheet with VBA sets up a few ini / txt type files required for another application.exe that people run. I want to make it hard for the users to know what is inside these ini files. I had an idea that is partially flawed:

- spreadsheet sets up the ini files and writes them to disk (I can do that)
- spreadsheet writes and runs a .BAT file that starts Application.EXE and after that removes the ini files (I think I can do that)

This is almost good enough, but the files only get deleted when application.exe ends and the BAT file continues. Users might Alt Tab out of application.exe and view the INI files which I would rather not have!

Would there be a way for VBA or BAT files to see that application.exe is no longer the active program and act accordingly? Since the users start application.exe from a macro in Excel, that would probably mean that Alt -Tab makes Excel the active program again which might be used to run a macro?

Any thoughts more than welcome!

Regards,
Niels

Hello,

The spreadsheet launches simulation software that is (and will always be) separate from excel.. If that was what you meant!
Cheers
Niels