+ Reply to Thread
Results 1 to 2 of 2

Running Solver in a loop without popup window

  1. #1
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,794

    Running Solver in a loop without popup window

    I’m running solver in a loop and since I’m checking a number of possible solutions I’ve set max time to 6 seconds.

    This speeds up the time it takes for solver to find a solution but if no solution is found after 6 second the “Show Trial Solution” window with its message “The maximum time limit was reached; continue anyway?” pops up.

    By clicking the “Stop” button Solver starts on the next loop so depending on the staring point it usually takes 2 – 3 “clicks” before a solution is found.

    Running the macro and keeping the “Alt” and the “S” button pressed will keep Solver running without stopping even if the “Show Trial Solution” window pops up for a second so I’ve tried to add the line

    Please Login or Register  to view this content.
    to my macro but I’ve not been able to make it work. Any hints on how to solve this?

    Alf

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,794

    Re: Running Solver in a loop without popup window

    Contacting the staff at Frontline I got a solution to this problem.

    This involves adding the line

    Please Login or Register  to view this content.
    to my macro and adding a function:

    Please Login or Register  to view this content.
    This looked rather promising at first but after doing more extensive testing it seems quicker to use the “Alt S” button combination.

    Alf

+ 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