I have another issue with somedates are missing.
code in vba
when i click the button it reads from the open text file name QrtlyRateDel.txt and writes QrtlyRateExludeMEdate.txt
this is the sample text file for qrtlyRateDel
ABCD,RUP,MKNT,08/29/08 0.21200000
ABCD,RUP,MKNT,08/28/08...
just date serial function
this shows 07/31/08 how come july has 31 days. what is the error in below one.
LastDay = Day(DateSerial(intOriginYear, intOriginMonth + 1, 0))
Msgbox LastDay
i am writing macro in attachment. grabing all date, rates and put it in text document
it is ok to show all dates and rate. but exclude last busines day. it shows including last business day.
how do i accomplish my task.
this is the main code
Sess0.Screen.Sendkeys("<HOME>")...
i am having script in vb6. when i click button it runs and should exclude last businessday onlybut it exclude other dates also. could you help in this regard.thanks a lot.
code isnhere:-
Private Sub cmdScanRemoveRates_Click()
Dim ReadRates
Dim strEffDate, strYear, strDayName
Dim Default...
i am having script in vb6. when i click button it runs and should exclude last businessday onlybut it exclude other dates also. could you help in this regard.thanks a lot.
code isnhere:-
Private Sub cmdScanRemoveRates_Click()
Dim ReadRates
Dim strEffDate, strYear, strDayName
Dim Default...
Hi !
i need to do quarter rate delete exclude last businss day of the month.
do you have any function for that please if you have please provide, thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.