Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver does not solve when called from a macro
We're having a problem using the solver in a macro. Using Excel 2000, two
users run the same file off a newtork share. The has a macro that calls the solver. One it works for, the other it does not. They both have SP1. They have the same Solver XLA and its referenced in the macro. When it does not work for the user, we can manually use the solver to get the answer. We recorded a macro of the manual solver, but when we run the macro the solver doesn't work. There are no errors, just the solver does nothing. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver does not solve when called from a macro
Macros disabled on that computer? See ToolsOptionsSecurity, Macro Security
-- Kind regards, Niek Otten "mjd918" wrote in message ... We're having a problem using the solver in a macro. Using Excel 2000, two users run the same file off a newtork share. The has a macro that calls the solver. One it works for, the other it does not. They both have SP1. They have the same Solver XLA and its referenced in the macro. When it does not work for the user, we can manually use the solver to get the answer. We recorded a macro of the manual solver, but when we run the macro the solver doesn't work. There are no errors, just the solver does nothing. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver does not solve when called from a macro
I checked and its on "medium".
Any other ideas? "Niek Otten" wrote: Macros disabled on that computer? See ToolsOptionsSecurity, Macro Security -- Kind regards, Niek Otten "mjd918" wrote in message ... We're having a problem using the solver in a macro. Using Excel 2000, two users run the same file off a newtork share. The has a macro that calls the solver. One it works for, the other it does not. They both have SP1. They have the same Solver XLA and its referenced in the macro. When it does not work for the user, we can manually use the solver to get the answer. We recorded a macro of the manual solver, but when we run the macro the solver doesn't work. There are no errors, just the solver does nothing. Any ideas? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver does not solve when called from a macro
I also want to add that no error is given, just the solver does not solve.
We're going to try and back up the version from SP2 to SP1 to see if that resolves it. MS reports a known problem using a solver from macro in SP3. "mjd918" wrote: I checked and its on "medium". Any other ideas? "Niek Otten" wrote: Macros disabled on that computer? See ToolsOptionsSecurity, Macro Security -- Kind regards, Niek Otten "mjd918" wrote in message ... We're having a problem using the solver in a macro. Using Excel 2000, two users run the same file off a newtork share. The has a macro that calls the solver. One it works for, the other it does not. They both have SP1. They have the same Solver XLA and its referenced in the macro. When it does not work for the user, we can manually use the solver to get the answer. We recorded a macro of the manual solver, but when we run the macro the solver doesn't work. There are no errors, just the solver does nothing. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing condition after solver called by macro | Excel Programming | |||
Can Solver solve this? | Excel Worksheet Functions | |||
How do you use solver to solve a polynomial | Excel Discussion (Misc queries) | |||
solver can not solve polynomial eq. where one variable is five di. | Excel Worksheet Functions | |||
Solver not Using Constraints when called from VB | Excel Programming |