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,

Re: Equation solving from VFP

> Thinking aloud, if you could guarantee 32-bit Excel was available you could > probably use Excel automation to do it, i.e. Actually, for Office automation it doesn't matter whether it's 32-bit or 64-bit, as long as it is installed on the machine. 32-bit is only relevant for DLLs or drivers.

Re: Equation solving from VFP

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