Solver functionality?

Hi all,

I know that in Excel there is a Solver-Functionality
allowing you to run optimizations or any kind of
iterations which are limited by constraint conditions.

Does anybody know a way to use the Excel (or any other)
solver in Access 97?

Many thanks,
Lorenz

You can automate Excel from Access. See the Microsoft Knowledge Base
article:

http://support.microsoft.com/?id=198571

--
HTH
Van T. Dinh
MVP (Access)



"Lorenz Wild" <lorenz.wild@gmx.de> wrote in message
news:218001c33ede$c01613c0$a401280a@phx.gbl...
> Hi all,
>
> I know that in Excel there is a Solver-Functionality
> allowing you to run optimizations or any kind of
> iterations which are limited by constraint conditions.
>
> Does anybody know a way to use the Excel (or any other)
> solver in Access 97?
>
> Many thanks,
> Lorenz

Many thanks!
>-----Original Message-----
>You can automate Excel from Access. See the Microsoft
Knowledge Base
>article:
>
>http://support.microsoft.com/?id=198571
>
>--
>HTH
>Van T. Dinh
>MVP (Access)
>
>
>
>"Lorenz Wild" <lorenz.wild@gmx.de> wrote in message
>news:218001c33ede$c01613c0$a401280a@phx.gbl...
>> Hi all,
>>
>> I know that in Excel there is a Solver-Functionality
>> allowing you to run optimizations or any kind of
>> iterations which are limited by constraint conditions.
>>
>> Does anybody know a way to use the Excel (or any other)
>> solver in Access 97?
>>
>> Many thanks,
>> Lorenz
>
>
>.
>