Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I use Excel solver from VFP
Message
From
06/03/2003 11:20:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
How can I use Excel solver from VFP
Miscellaneous
Thread ID:
00762224
Message ID:
00762224
Views:
73
I can create a macro in Excel to use the Solver add-in in a spreadsheet.

The lines in VB editor look like this:
SolverOk SetCell:="$C$4", MaxMinVal:=2, ValueOf:="0", ByChange:="$C$4:$C$7"
SolverSolve

In VFP it should be:
XL.SolverOK("$C$4",2,"0","$C$4:$C$7")
XL.SolverSolve

But that doesn't work because SolverOK and SolverSolve are "Unknow" methods for XL.

How can I reach the Solver add-in from VFP?
Thanks for your help!
Next
Reply
Map
View

Click here to load this message in the networking platform