Hi.
(1)
' Solve w/ no prompts
SolverSolve True
' Keep Final values
SolverFinish 1

(2)
Solver doesn't work well with data spread out on other sheets.
Before making big changes, try removing any spaces in any sheet names.
Be sure to remove any spaces in the workbook name also.
Not guaranteed here, but it may help.
--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"JamesB" wrote in message
...
Thank you so much.

I'm ALOT closer to getting this thing nailed than I was a week ago, and I
really appreciate the assistance from both of you.

I've got it all "working", but there are two (hopefully simple) tweaks I'd
like to make before I implement the spreadsheet full-time:

1) As I explained before, the macro I recorded performs about 16 "solver"
functions. You know how when you use Solver, after the equation has been
"solved", you get that annoying pop-up window saying something along the
lines of "Do You Wish To Keep Solvers Solutions" etc.. The macro works
PERFECTLY, however, after it is run I have to click "OK" on 16 of these
silly
pop-up windows to accept the changes! Is there any way I can avoid this
happening?

2) Alot of the data used in the solver equation is tucked away on numerous
spreadsheets that I don't particularly want to "see". I recorded the
macro,
then hid any unneccessary spreadsheets - unfortunately, this includes
worksheets with some of the data required by solver. For some reason, if
these spreadsheets are hidden, solved adopts some kind of "bug" halfway
through calculation and the macro doesn't work. Again, is there any way to
hide these worksheets but still have the macro work?

Appreciate any further info you can share.

THANKS!!!

"Dana DeLouis" wrote:

Hi. You just need to set a reference to Solver in vba.
Here are the steps...

http://support.microsoft.com/kb/213689/en-us

Good luck.

[The error message is "Sub or Function not defined"]

--
Dana DeLouis
Windows XP & Office 2003


"JamesB" wrote in message
...
Hey guys,

Thanks for your assistance.

I'm having some problems still with the Macro thing (first shot at it).
I
basically just "started recording a macro", performed the solver task
(i.e.
Tools Solver Set Target Cell etc. Solve) then "stopped
recording". I
saved the worksheet, then tried to run the macro and got the following:

<img
src="http://img136.imageshack.us/img136/8928/excelscreenshotog7.png"
Does this make sense to you?
Apologies for my naivety.
Again, appreciate your help!

<snip