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
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
- (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.
- (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]
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. š
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Wednesday, September 5, 2018 4:47 PM To: profoxtech@leafe.com Subject: 2 Excel questions using automation from VFP9SP2
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@mbso... ** 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.
Report [OT] Abuse: http://leafe.com/reportAbuse/c098c4933dff7f770255511062c0dee9@mbsoftwaresolu...
On Wed, Sep 5, 2018 at 5:45 PM Richard Kaye rkaye@invaluable.com wrote:
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. š
--
rk
Oh, yeah, date math was my thing. From
https://support.office.com/en-us/article/NETWORKDAYS-function-48E717BF-A7A3-...
Is the spec. For VFP, we'll use an array of holidays range than Excel ranges...
BONUS: Validated against http://www.workingdays.us/
* Test Work days * duplicate Excel function NETWORKDAYS * NETWORKDAYS(start_date, end_date, [holidays]) * The NETWORKDAYS function syntax has the following arguments: * Start_date Required. A date that represents the start date. * End_date Required. A date that represents the end date. * Holidays Optional. An optional range of one or more dates to * exclude from the working calendar, such as state and federal holidays * and floating holidays. The list can be either a range of cells that * contains the dates or an array constant of the serial numbers that represent the dates.
* DO TEST && to test, uncomment this line
FUNCTION NetWorkDays(start_date as Date, end_date as Date, Holidays as array)
counter = 0 FOR count = 1 TO ALEN(Holidays) holiday = Holidays[count] IF(BETWEEN(holiday, start_date, end_date) and IsWorkDay(holiday)) counter = counter -1 ENDIF NEXT
DO WHILE start_date <=end_date IF IsWorkDay(start_date) counter = counter +1 ENDIF start_date=start_date +1 ENDDO
RETURN counter
FUNCTION IsWorkDay(thedate as Date) * ASSuMEs FDOW is 1, for VFP 6-7-8 compat. Add ,1 3rd parameter for VFP9, assumes US-based Sat/Sun weekends, RETURN BETWEEN(DOW(thedate),2,6)
PROCEDURE test DIMENSION Holidays[10] Holidays[1] = {^2018-01-01} Holidays[2] = {^2018-01-15} Holidays[3] = {^2018-02-19} Holidays[4] = {^2018-05-28} Holidays[5] = {^2018-07-04} Holidays[6] = {^2018-09-03} Holidays[7] = {^2018-10-08} Holidays[8] = {^2018-11-12} Holidays[9] = {^2018-11-22} Holidays[10] = {^2018-12-25}
ACTIVATE SCREEN CLEAR ? "July: " + TRANSFORM(NetWorkDays({^2018-07-01}, {^2018-7-31}, @Holidays)) ? "1st half: " + TRANSFORM(NetWorkDays({^2018-01-01}, {^2018-7-31}, @Holidays)) ? "Full Year: " + TRANSFORM(NetWorkDays({^2018-01-01}, {^2018-12-31}, @Holidays))
ENDPROC
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Try again...
Oh, yeah, date math was my thing. From
https://support.office.com/en-us/article/NETWORKDAYS-function-48E717BF-A7A3-...
Is the spec. For VFP, we'll use an array of holidays range than Excel ranges...
BONUS: Validated against http://www.workingdays.us/
* Test Work days * duplicate Excel function NETWORKDAYS * NETWORKDAYS(start_date, end_date, [holidays]) * The NETWORKDAYS function syntax has the following arguments: * Start_date Required. A date that represents the start date. * End_date Required. A date that represents the end date. * Holidays Optional. An optional range of one or more dates to * exclude from the working calendar, such as state and federal holidays * and floating holidays. The list can be either a range of cells that * contains the dates or an array constant of the serial numbers that represent the dates.
* DO TEST && to test, uncomment this line
FUNCTION NetWorkDays(start_date as Date, end_date as Date, Holidays as array)
counter = 0 FOR count = 1 TO ALEN(Holidays) holiday = Holidays[count] IF(BETWEEN(holiday, start_date, end_date) and IsWorkDay(holiday)) counter = counter -1 ENDIF NEXT
DO WHILE start_date <=end_date IF IsWorkDay(start_date) counter = counter +1 ENDIF start_date=start_date +1 ENDDO
RETURN counter
FUNCTION IsWorkDay(thedate as Date) * ASSuMEs FDOW is 1, for VFP 6-7-8 compat. Add ,1 3rd parameter for VFP9, assumes US-based Sat/Sun weekends, RETURN BETWEEN(DOW(thedate),2,6)
PROCEDURE test DIMENSION Holidays[10] Holidays[1] = {^2018-01-01} Holidays[2] = {^2018-01-15} Holidays[3] = {^2018-02-19} Holidays[4] = {^2018-05-28} Holidays[5] = {^2018-07-04} Holidays[6] = {^2018-09-03} Holidays[7] = {^2018-10-08} Holidays[8] = {^2018-11-12} Holidays[9] = {^2018-11-22} Holidays[10] = {^2018-12-25}
ACTIVATE SCREEN CLEAR ? "July: " + TRANSFORM(NetWorkDays({^2018-07-01}, {^2018-7-31}, @Holidays)) ? "1st half: " + TRANSFORM(NetWorkDays({^2018-01-01}, {^2018-7-31}, @Holidays)) ? "Full Year: " + TRANSFORM(NetWorkDays({^2018-01-01}, {^2018-12-31}, @Holidays))
ENDPROC
On Fri, Sep 7, 2018 at 11:33 AM Ted Roche tedroche@gmail.com wrote:
On Wed, Sep 5, 2018 at 5:45 PM Richard Kaye rkaye@invaluable.com wrote:
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. š
--
rk
Oh, yeah, date math was my thing. From
https://support.office.com/en-us/article/NETWORKDAYS-function-48E717BF-A7A3-...
Is the spec. For VFP, we'll use an array of holidays range than Excel ranges...
BONUS: Validated against http://www.workingdays.us/
- Test Work days
- duplicate Excel function NETWORKDAYS
- NETWORKDAYS(start_date, end_date, [holidays])
- The NETWORKDAYS function syntax has the following arguments:
- Start_date Required. A date that represents the start date.
- End_date Required. A date that represents the end date.
- Holidays Optional. An optional range of one or more dates to
- exclude from the working calendar, such as state and federal holidays
- and floating holidays. The list can be either a range of cells that
- contains the dates or an array constant of the serial numbers that
represent the dates.
- DO TEST && to test, uncomment this line
FUNCTION NetWorkDays(start_date as Date, end_date as Date, Holidays as array)
counter = 0 FOR count = 1 TO ALEN(Holidays) holiday = Holidays[count] IF(BETWEEN(holiday, start_date, end_date) and IsWorkDay(holiday)) counter = counter -1 ENDIF NEXT
DO WHILE start_date <=end_date IF IsWorkDay(start_date) counter = counter +1 ENDIF start_date=start_date +1 ENDDO
RETURN counter
FUNCTION IsWorkDay(thedate as Date)
- ASSuMEs FDOW is 1, for VFP 6-7-8 compat. Add ,1 3rd parameter for VFP9,
assumes US-based Sat/Sun weekends, RETURN BETWEEN(DOW(thedate),2,6)
PROCEDURE test DIMENSION Holidays[10] Holidays[1] = {^2018-01-01} Holidays[2] = {^2018-01-15} Holidays[3] = {^2018-02-19} Holidays[4] = {^2018-05-28} Holidays[5] = {^2018-07-04} Holidays[6] = {^2018-09-03} Holidays[7] = {^2018-10-08} Holidays[8] = {^2018-11-12} Holidays[9] = {^2018-11-22} Holidays[10] = {^2018-12-25}
ACTIVATE SCREEN CLEAR ? "July: " + TRANSFORM(NetWorkDays({^2018-07-01}, {^2018-7-31}, @Holidays)) ? "1st half: " + TRANSFORM(NetWorkDays({^2018-01-01}, {^2018-7-31}, @Holidays)) ? "Full Year: " + TRANSFORM(NetWorkDays({^2018-01-01}, {^2018-12-31}, @Holidays))
ENDPROC
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
- (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.
- (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]
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
- (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.
- (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).
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
- (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.
- (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]
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
- (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.
- (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]
For Holidays in various countries, please check the calendar class in GitHub VFp Koen
Op do 6 sep. 2018 om 23:41 schreef Stephen Russell srussell705@gmail.com:
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
- (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.
- (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]
No, the calendar table has a column to specify if a date is a holiday.
On 6 September 2018 17:41:04 GMT-04:00, Stephen Russell srussell705@gmail.com wrote:
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
- (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.
- (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]
This is the table I use:
USE [Calendar] GO
/****** Object: Table [dbo].[Calendar] Script Date: 06/09/2018 06:02:16 PM ******/ SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[Calendar]( [dt] [date] NOT NULL, [isWeekday] [bit] NULL, [isHoliday] [bit] NULL, [Y] [smallint] NULL, [FY] [smallint] NULL, [Q] [tinyint] NULL, [M] [tinyint] NULL, [D] [tinyint] NULL, [DW] [tinyint] NULL, [monthname] [varchar](9) NULL, [dayname] [varchar](9) NULL, [W] [tinyint] NULL, [HolidayDescription] [varchar](32) NULL, [cal_pk] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, CONSTRAINT [PK_Calendar] PRIMARY KEY CLUSTERED ( [cal_pk] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
GO
SET ANSI_PADDING OFF GO
On 6 September 2018 17:41:04 GMT-04:00, Stephen Russell srussell705@gmail.com wrote:
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
- (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.
- (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]
On 2018-09-06 17:41, Stephen Russell wrote:
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.
It works fine in Excel; I wanted to incorporate the idea into my framework for when needed later on. Just didn't want to have to fire up Excel just to use this function.
On 06/09/2018 04:38 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
it's a slick formula for determining the TIME that's passed within the workday hours set (not just days; that'd be simple).
Are you sure about that? Everywhere I've looked it says it returns the number of Whole workdays between two dates.
Frank.
Frank Cazabon
On 2018-09-06 20:31, Frank Cazabon wrote:
On 06/09/2018 04:38 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
it's a slick formula for determining the TIME that's passed within the workday hours set (not just days; that'd be simple).
Are you sure about that? Everywhere I've looked it says it returns the number of Whole workdays between two dates.
Well, ok, I see it as a fraction representing the time but yeah, it's a fraction of the day total using the parameters. We use it to show total time spent on help desk tickets by response, SME time, and total time spent.
I guess it depends on your perspective.
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
- (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.
- (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]
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
- (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.
- (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]
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. https://docs.microsoft.com/en-gb/visualstudio/vsto/how-to-programmatically-c...
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
- (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.
- (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]
-
Fernando D. Bozzo -
Frank Cazabon -
Koen Piller -
mbsoftwaresolutionsļ¼ mbsoftwaresolutions.com -
Richard Kaye -
Stephen Russell -
Ted Roche