+ Reply to Thread
Results 1 to 3 of 3

running multiple macros, using solver

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Mac 2011
    Posts
    34

    running multiple macros, using solver

    I am trying to use solver to find what time it takes for the value with no failures to be the same as the value with. there are a total of about 100 different individual components and i wish to test each individually.
    i have written a macro to run solver for me and this works fine,

    Please Login or Register  to view this content.
    but i cannot get the copy and paste to happen after solver has finished calculating.

    please help me solve this, i have spent hours trying to work it out already. Thanks.

    Moderator Note:

    Pls use code tags around your code next time as per forum rules.
    Last edited by will.girling; 11-18-2013 at 11:56 AM.

  2. #2
    Registered User
    Join Date
    11-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Mac 2011
    Posts
    34

    Re: running multiple macros, using solver

    it works on windows using office 2010, no idea why, but kinda a solution

  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: running multiple macros, using solver

    it works on windows using office 2010, no idea why
    Perhaps this will make it easier to understand?

    There is a serious problem using Solver for Excel in Office 2011 when it is called from vba. Because Solver is a separate application, control must be transferred from Excel to Solver, and this control does not occur until after vba has terminated. This means that any processing that occurs in the vba program after the call to SolverSolve will be completed before Solver has done its task.
    Alf

+ 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. [SOLVED] Running Multiple Macros on Different Cell Changes
    By SF007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2012, 01:55 PM
  2. Running Macros on multiple worksheets
    By shivrklfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2012, 11:11 AM
  3. [SOLVED] running multiple macros
    By petelomax in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-03-2012, 07:32 AM
  4. [SOLVED] Using Excel Solver multiple times with macros
    By Barry T in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2005, 04:06 PM
  5. running multiple macros
    By spog00 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2005, 12:57 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