+ Reply to Thread
Results 1 to 3 of 3

How to change the max time limit for Frontline Analytic solver in VBA?

  1. #1
    Registered User
    Join Date
    12-23-2020
    Location
    Canada
    MS-Off Ver
    MS 365
    Posts
    1

    How to change the max time limit for Frontline Analytic solver in VBA?

    I would like to be able to change the max time limit for the Frontline Analytic solver add-in in excel direct with my VBA code instead of having to go into the solver. I would like to have a cell in my worksheet where I enter the time I want the solver to run (exemple : 120 seconds) and when I run my code, it changes automaticly the max time limit.

    I tried the
    Please Login or Register  to view this content.
    method but it doesn't work since I am not using the built-in solver in Excel.

    Secondly, I would like for the code to automaticly press the "Stop" button once the time limit has been reached since I am running a loop and performing multiple optimizations one after the other.

    Thank you

  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,758

    Re: How to change the max time limit for Frontline Analytic solver in VBA?

    For you first question perhaps

    Please Login or Register  to view this content.
    No idea to to solve second question.

    Alf

    Ps A Merry Christmas to you

  3. #3
    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,758

    Re: How to change the max time limit for Frontline Analytic solver in VBA?

    My first answer don't work for the "normal" Excel Solver and I've tested your original code snippet and this works in my solver as well. The only difference I can see from what works for me I use MaxTime and my setting for Cells is a bit different from yours (3,3) or is that a typo in the upload? Using maxtime instead of MaxTime will not matter as it will be modified by VBA but "Cells(3,3) could be your problem as this need the extra space after " ,".

    This works for me in Excel 2010:

    Please Login or Register  to view this content.
    Alf
    Last edited by Alf; 12-25-2020 at 05:56 AM.

+ 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. Replies: 5
    Last Post: 10-09-2020, 03:33 AM
  2. Replies: 1
    Last Post: 11-08-2017, 03:16 PM
  3. AHP ( Analytic Hirarchical Process)
    By altarray in forum Excel General
    Replies: 2
    Last Post: 01-04-2013, 08:49 PM
  4. Analytic question - within Excel
    By hunnel in forum Excel General
    Replies: 1
    Last Post: 06-27-2012, 09:36 AM
  5. Solver Time Limit
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2011, 11:45 AM
  6. Replies: 1
    Last Post: 08-08-2006, 01:00 PM
  7. Excel Solver: How do I limit the contents of a cell to 1=True or 0
    By Brian Patrick Gilbert in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-08-2005, 12:06 PM

Tags for this Thread

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