+ Reply to Thread
Results 1 to 4 of 4

Run external Program

  1. #1
    Registered User
    Join Date
    07-22-2020
    Location
    Lake Cowichan, BC
    MS-Off Ver
    16
    Posts
    8

    Run external Program

    HI;
    I have a macro which loads and runs a external program in a minimized state.

    The program starts and runs fine minimized. The issue I have is I want to return back to the worksheet page as soon as the program loads but instead I get kicked back to windows desktop. Excel is still running but minimized so it takes another keystroke to restore Excel.


    This is the code to run the external program but beyond that I dont know what the next step is. Any idea how one can do this.

    code
    -------
    retval = Shell("C:\Program Files (x86)\circuitone\Programs\sago32.exe")
    -------

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,906

    Re: Run external Program

    Hi, I don't know what your program does but if you just ave a button that runs that program and that program does not require focus, I would assume Excel remains in the foreground.

    What if you run it like this:

    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    07-22-2020
    Location
    Lake Cowichan, BC
    MS-Off Ver
    16
    Posts
    8

    Re: Run external Program

    Thank for trying but no success. Excel minimizes and windows desktop is up

    Dave

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,906

    Re: Run external Program

    Hi Dave ,
    What if you set the window to maximize, does it still minimize?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Controlling an external program
    By mic_bo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2014, 02:43 PM
  2. Linking with external program
    By ckb4211 in forum Excel General
    Replies: 1
    Last Post: 08-08-2011, 10:26 AM
  3. Running a external Program
    By MarkS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2006, 03:30 AM
  4. [SOLVED] Use Macro to Run External Program
    By Peter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 12:20 AM
  5. Hyperlink to an external program
    By furbiuzzu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2005, 06:17 PM
  6. Closing a external legacy program using VBA
    By Byron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-09-2005, 12:05 AM
  7. Run external program.
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2005, 08:06 AM

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