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

2018-10-16 Thread mbsoftwaresolutions
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 wrote: I forgot to post the formula in text here: =(NETWORKDAYS(A2,B2)-1)*(

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

2018-10-15 Thread Fred Taylor
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 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 programat

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

2018-10-15 Thread mbsoftwaresolutions
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. On 2018-10-15 17:05, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: See screenshot: https://www.screencast.com/t/wzLweduy General s

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

2018-10-15 Thread mbsoftwaresolutions
See screenshot: https://www.screencast.com/t/wzLweduy General scenario: 2 input datetime values, with output being the native Excel command NetworkDays result on those 2 cells using 9 a.m. to 5:30 p.m. bounds, giving me the time elapsed between DateTime1 and DateTime2. I want to supply a sta