Re: Equation solving from VFP

Thanks Alan

I could certainly do that and I already have a workbook set up but I would prefer a non-automation method if possible.

Paul

On 14/12/2022 09:10, Alan Bourke wrote:

Thinking aloud, if you could guarantee 32-bit Excel was available you could probably use Excel automation to do it, i.e.

Create a Workbook programmatically Fill defined cells with your input values Do a Goal Seek with result in a defined cell Read that value back to VFP.

 Range("B4").GoalSeek Goal:=-900, ChangingCell:=Range("B3")