Re: VFP9SP2 & Excel automation -- how to enter this formula into a cell programatically from VFP?

Thanks, Fred. I was so close!

On 2018-10-15 17:18, Fred Taylor wrote:

ox.Cells(yourrow,yourcolumn).Formula = [=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)]

Fred

On Mon, Oct 15, 2018 at 2:06 PM mbsoftwaresolutions@mbsoftwaresolutions.com wrote:

...

I forgot to post the formula in text here:

=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)

I can't get that entered programatically from VFP.