Automate optimization runs?

["Gary Fritz" <fritz@xxxxxxxx>]

I'm afraid I already know the answer to this, but...

Is there any way to automate optimization runs in TS4?  I want to 
test a system over a broad range of data, and that requires changing 
the date &etc before each run.  Doing that by hand is painfully slow 
and error-prone.

As far as I know TS doesn't support this.  I'd like to have some way 
to "drive" TS from another process so I could set up a series of 
optimization runs and let it run overnight.  Does anyone know of a 
way to do this?

A while back someone (sorry, forgot his name) posted an Excel macro 
that lets you change the SYMBOL in a chart and thereby cause the 
system to be run again on the new system.  If I have to, I may try to 
modify this tool to change data dates, modify system parameters, and 
set up new optimization runs.  I can do all that via typing and 
keyboard shortcuts.  (The Excel macro uses the SendKeys statement to 
"type" into the TS window.)  I haven't used VBA but I can figure it 
out if I have to.  But even if I get it to run the system, I don't 
see how I can save out the optimization reports from each run, since 
that requires mouse clicks on the "Copy" or "Save to File" icons on 
the optimization report, and SendKey doesn't do mouse clicks...  Is 
there any other way to save the optimization results?

If someone has a better solution, I'd love to hear it!

Thanks!
Gary