Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I use Excel solver from VFP
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
How can I use Excel solver from VFP
Divers
Thread ID:
00762224
Message ID:
00762224
Vues:
72
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!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform