+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    01-04-2004
    Location
    Netherlands
    Posts
    53

    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

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,647

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

    Which other programs ?
    Maybe that can be accomplished by VBA too.



  3. #3
    Registered User
    Join Date
    01-04-2004
    Location
    Netherlands
    Posts
    53

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

    Hello,

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1