General information
Category:
COM/DCOM and OLE Automation
Title:
How can I use Excel solver from VFP
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only