Results 1 to 4 of 4
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I have 2 solver questions, that I cannot resolve

    1. Sometimes Solver (Even though the Constraint is set to Integer).
      Will return a decimal number. Is there a way to prevent this?
    2. This is Solver VBA issue
      In VBA routine that calls Solver, is there any way to stop solver turning back on Status Bar and screen Updating.
      Even if BOTH are turned off prior to calling the solver, Solver
      itself turns them back on.
      Indeed even making changes to the Solver xla add-in, the original code is regenerated the next time Excel is loaded
      Anyone got any idea?
      Or are we looking at a Feature?
    Andrew

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you change the code in the add-in, it won't be regenerated as long as you saved the add-in. (don't assume that because you clicked the Save button in the VBE, it actually saved...)
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Thanks Rory (for answers to BOTH questions).
    There was I assuming that when MS told me it was saving it was.

    I'll revisit the changes and saves again.

    Shame about that array 65536 limit though (not this thread)

    I have modified solver now (silly me) and all appears ok.

    Thanks again
    Andrew

  4. #4
    New Lounger
    Join Date
    Jan 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do you change xla?
    I'm not familiar with Excel and VBA, but need to stop Solver from updating status bar.
    Thank you.

Posting Permissions

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