Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2018-09-05 15:47:27 Link
See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D
1) (rose highlight) I've forgotten how to get Excel to close without
asking me this every time. Currently, I'm just calling the .Quit()
method of my Excel object. I tried passing a .T. parm but that failed.
2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
formula to work in VFP? Would be neat to have this and I thought
perhaps someone already built it.
tia,
--Mike
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/c098c4933dff7f770255511062c0dee9@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Frank Cazabon
Posted: 2018-09-05 16:43:52 Link
Is it displayalerts for question 1?
On 5 September 2018 16:47:27 GMT-04:00, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D
>
>1) (rose highlight) I've forgotten how to get Excel to close without
>asking me this every time. Currently, I'm just calling the .Quit()
>method of my Excel object. I tried passing a .T. parm but that failed.
>
>2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
>formula to work in VFP? Would be neat to have this and I thought
>perhaps someone already built it.
>
>tia,
>--Mike
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/14A6CE70-5EC2-47F4-B486-44CD859A0F74@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Richard Kaye
Posted: 2018-09-05 16:45:39 Link
1 - set the saved property to .t. before you get rid of the Excel object.
m.loExcel.ActiveWorkbook.Saved=.t.
2 - I bet Ted wants a crack at that one.
Author: Frank Cazabon
Posted: 2018-09-05 16:54:28 Link
I use a calendar table (albeit in SQL server but that shouldn't matter). Then it's just a matter of some simple queries.
On 5 September 2018 16:47:27 GMT-04:00, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D
>
>1) (rose highlight) I've forgotten how to get Excel to close without
>asking me this every time. Currently, I'm just calling the .Quit()
>method of my Excel object. I tried passing a .T. parm but that failed.
>
>2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
>formula to work in VFP? Would be neat to have this and I thought
>perhaps someone already built it.
>
>tia,
>--Mike
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CC9CB697-6602-488A-A5EC-4D7326387CFB@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2018-09-05 17:22:40 Link
Idea on network days
for loop between the days
insert to a cursor if the DOW if not a weekend.
count rows of cursor.
Holidays you are on your own :)
On Wed, Sep 5, 2018 at 4:35 PM <mbsoftwaresolutions@mbsoftwaresolutions.com>
wrote:
> See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D
>
> 1) (rose highlight) I've forgotten how to get Excel to close without
> asking me this every time. Currently, I'm just calling the .Quit()
> method of my Excel object. I tried passing a .T. parm but that failed.
>
> 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
> formula to work in VFP? Would be neat to have this and I thought
> perhaps someone already built it.
>
> tia,
> --Mike
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYLQUcX6z3vShF2Lih2_W_cTiUZk5nzJdpyNbE4WMNu8Aw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Fernando D. Bozzo
Posted: 2018-09-05 17:23:30 Link
Hi:
About (1), y thinq you could use the same value that makes Word quit
without saving, which is *Quit(0)* (can't find any doc about Quit)
Another option is closing de document without saving using *Close(0)*
method then quitting.
Hope it helps.
Fernando D. Bozzo
2018-09-05 22:47 GMT+02:00 <mbsoftwaresolutions@mbsoftwaresolutions.com>:
> See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D
>
> 1) (rose highlight) I've forgotten how to get Excel to close without
> asking me this every time. Currently, I'm just calling the .Quit() method
> of my Excel object. I tried passing a .T. parm but that failed.
>
> 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
> formula to work in VFP? Would be neat to have this and I thought perhaps
> someone already built it.
>
> tia,
> --Mike
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAGQ_JumoPZvcsBS_J09kc2AqPU5taRxAnHiCjNG5GE7mpZactA@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2018-09-06 15:38:11 Link
On 2018-09-05 17:54, Frank Cazabon wrote:
> I use a calendar table (albeit in SQL server but that shouldn't
> matter). Then it's just a matter of some simple queries.
>
> On 5 September 2018 16:47:27 GMT-04:00,
> mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>> See screenshot for case matter:
>> https://www.screencast.com/t/VNdRiSd1D
>>
>> 1) (rose highlight) I've forgotten how to get Excel to close without
>> asking me this every time. Currently, I'm just calling the .Quit()
>> method of my Excel object. I tried passing a .T. parm but that
>> failed.
>>
>> 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
>> formula to work in VFP? Would be neat to have this and I thought
>> perhaps someone already built it.
Frank -- it's a slick formula for determining the TIME that's passed
within the workday hours set (not just days; that'd be simple).
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/d491dd76de64ba00d6b734f70dd7fbbc@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2018-09-06 15:39:11 Link
No no...despite the name, it's not a count of days; it's a count of the
TIME (hours/minutes) within the workday parameters set.
Counting days would be easy.
On 2018-09-05 18:22, Stephen Russell wrote:
> Idea on network days
> for loop between the days
> insert to a cursor if the DOW if not a weekend.
> count rows of cursor.
>
> Holidays you are on your own :)
>
> On Wed, Sep 5, 2018 at 4:35 PM
> <mbsoftwaresolutions@mbsoftwaresolutions.com>
> wrote:
>
>> See screenshot for case matter:
>> https://www.screencast.com/t/VNdRiSd1D
>>
>> 1) (rose highlight) I've forgotten how to get Excel to close without
>> asking me this every time. Currently, I'm just calling the .Quit()
>> method of my Excel object. I tried passing a .T. parm but that
>> failed.
>>
>> 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
>> formula to work in VFP? Would be neat to have this and I thought
>> perhaps someone already built it.
>>
>> tia,
>> --Mike
>>
>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/0b9e276fe817c836bfed24930f7d1d1b@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Frank Cazabon
Posted: 2018-09-06 15:57:36 Link
Ah, didn't know that. My quick Google of it only mentioned days.
Even if it were just days, it's definitely not that simple when you take into consideration holidays and that some work days are Saturdays in some places/jobs.
I still see those complications with calculating the time.
On 6 September 2018 16:38:11 GMT-04:00, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>On 2018-09-05 17:54, Frank Cazabon wrote:
>> I use a calendar table (albeit in SQL server but that shouldn't
>> matter). Then it's just a matter of some simple queries.
>>
>> On 5 September 2018 16:47:27 GMT-04:00,
>> mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>>> See screenshot for case matter:
>>> https://www.screencast.com/t/VNdRiSd1D
>>>
>>> 1) (rose highlight) I've forgotten how to get Excel to close without
>>> asking me this every time. Currently, I'm just calling the .Quit()
>>> method of my Excel object. I tried passing a .T. parm but that
>>> failed.
>>>
>>> 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
>>> formula to work in VFP? Would be neat to have this and I thought
>>> perhaps someone already built it.
>
>
>
>Frank -- it's a slick formula for determining the TIME that's passed
>within the workday hours set (not just days; that'd be simple).
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4FDE88F6-66CF-4BEC-A532-1126ABDA541E@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2018-09-06 16:41:04 Link
Do you have a table for Holidays? We use it in our system but it also
identifies the country you are in for work. We are USA, CA, UK for now.
I too tried the formula in base format in excel and it returns days when my
two cells were 7-30-2018 13:00:00 and 08-01-2018 23:00:00.
I didn't monkey around with cell settings to see if it changed.
On Thu, Sep 6, 2018 at 4:00 PM Frank Cazabon <frank.cazabon@gmail.com>
wrote:
> Ah, didn't know that. My quick Google of it only mentioned days.
>
> Even if it were just days, it's definitely not that simple when you take
> into consideration holidays and that some work days are Saturdays in some
> places/jobs.
>
> I still see those complications with calculating the time.
>
> On 6 September 2018 16:38:11 GMT-04:00,
> mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
> >On 2018-09-05 17:54, Frank Cazabon wrote:
> >> I use a calendar table (albeit in SQL server but that shouldn't
> >> matter). Then it's just a matter of some simple queries.
> >>
> >> On 5 September 2018 16:47:27 GMT-04:00,
> >> mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
> >>> See screenshot for case matter:
> >>> https://www.screencast.com/t/VNdRiSd1D
> >>>
> >>> 1) (rose highlight) I've forgotten how to get Excel to close without
> >>> asking me this every time. Currently, I'm just calling the .Quit()
> >>> method of my Excel object. I tried passing a .T. parm but that
> >>> failed.
> >>>
> >>> 2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS
> >>> formula to work in VFP? Would be neat to have this and I thought
> >>> perhaps someone already built it.
> >
> >
> >
> >Frank -- it's a slick formula for determining the TIME that's passed
> >within the workday hours set (not just days; that'd be simple).
> >
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYKor-u5rvXBSpo2+V8YQcqqCYSjbQGXf6eOK+JZbm5ciQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.