Re: webquery and solver macros

now, is there a way to avoid this, or delete constraints?

Hi. One way is to just run the macro, and after each solve, then delete the
constraints.
One can delete constraints in a loop, but I have found "Resetting"
everything to be an easier solution. On does this with SolverReset.
Here's an example..

For j = 1 To 20
SolverReset
SolverOk [A1], 1, [B1]
'...etc
Next j

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


"icestationzbra"
<icestationzbra.23nlem_1140649801.0463@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:icestationzbra.23nlem_1140649801.0463@xxxxxxxxxxxxxxxxxxxxxxxx

hi,

recently, i have been dabbling with recording webqueries and solver
procedures.

i have observed the following.

webquery:

when i record (macro) a webquery from a website, for example - yahoo
finance, i can assign (or define) a range name or reference for that
table (viz, currency). when i execute the webquery macro over and over
again, every time it runs - it creates a new name viz, currency_1,
currency_2, currency_3, and this goes on. i would have imagined it
would overwrite the existing name or reference. thats what i intend it
to do.

is there a way around it? i have not been able to figure out, first,
how to avoid this, and second, how to delete a reference name for which
i know the first few letters will be 'currency' (in my case).

solver:

solver is defined with a set of constraints (without which there is no
purpose of using a solver, duh). when i record a solver macro, and run
it over and over again, probably on 7th or 8th turn the solver will
refuse to solve it for you. here is what happens. it would have added
the same constraint(s) as many number of times as you have run the
solver macro. as a denoument, the solver will not be able to spit out a
solution.

now, is there a way to avoid this, or delete constraints? i know that
we can record the process of deleting a constraint. if it were the
first time you were running the macro, and there were no constraints,
the program would err.

i would appreciate any help that comes this way.

thanks,

mac.


--
icestationzbra
------------------------------------------------------------------------
icestationzbra's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=4580
View this thread: http://www.excelforum.com/showthread.php?threadid=515550




.

Relevant Pages

  • Re: Solver programming questions
    ... Recording a macro usually works. ... This allows you make sure you do not have any constraints that you are not aware of. ... Creating a macro by recording the use of Solver did not pickup the constraint statements. ... First problem is that the solver runs successfully on the first occasion the ...
    (microsoft.public.excel.programming)
  • Re: Solver programming questions
    ... "Dana DeLouis" wrote: ... Recording a macro usually works. ... This allows you make sure you do not have any constraints that you are ... recording the use of Solver did not pickup the constraint statements. ...
    (microsoft.public.excel.programming)
  • Re: Solver programming questions
    ... Thanks Dana, I omitted to put C1 in exclamation marks so that part works fine ... Can you help me code constraints in the macro please? ... recording the use of Solver did not pickup the constraint statements. ...
    (microsoft.public.excel.programming)
  • webquery and solver macros
    ... i have been dabbling with recording webqueries and solver ... when i record (macro) a webquery from a website, ... solver is defined with a set of constraints (without which there is no ...
    (microsoft.public.excel.misc)
  • Re: Visual Basic Macro For Solver
    ... I am not saying that. ... I want to write a macro for running solver. ... >> but each time is saving the constraints on the window. ...
    (microsoft.public.excel.programming)