Search results for query: *

ok skip again you spent lot of time for me. thanks a lot. whcih variable should i check in watch window. so that i can check all variable in the function

skip thanks a lot for your great help. but now it is missing whole month

the whole thing has written in vb. i could modify in this only. could you please help me please.

SKIP! Nothing showing in watch window when it comes on 08/22/08 fall in friday. it skips the below code and it goes to end if. strCurrent Day = friday. If strCurrentDay = "Friday" And strNextDay = "Saturday" And strAfterNextday = "Sunday" Then ElseIf strCurrentDay = "Friday" And...

skip when i step through it is not skippking it is printing. when i run it is skipping

Skip thanks for your valuable and precious time. i did go through step there is no skiping code in above function. is there any other way to find out.

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...

it is working i made mistake

sorry i missed another line LastDay = Day(DateSerial(intOriginYear, intOriginMonth + 1, 0)) Date = intOriginMonth & "/" & LastDay & "/0" & intOriginYear Msgbox Date

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

thanks a lot! it is working great.

Skip Again thanks a lot. i will try it tomorrow and get back to you. thank you once agian.

Skip thank you very much for your precious time. i am still struggling. i am trying to do from the screen. Sess0.Screen.Sendkeys("<HOME>") Sess0.Screen.Sendkeys("GU<Tab>abcd,USD,") Sess0.Screen.PutString "???",1,20 Sess0.Screen.PutString ConstStr,1,23 Sess0.Screen.PutString...

skip thanks i am writing macro in attachmaent. so the above macro which i provided can i include yours and try. and please i am so confused where do i have to includeyours.

Skip the above macro has checking from current year to last 10 years. but i need to check only current year and previous year . i did checked year (now ) and year (now)-1 but still it is beyond that checking. could you help me

sorry skip it is not working. i have the above macrow which has given the text documnet including last business day . i need only except last business day. thanks for your help.

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...

Skip thnnks. ctualy every quarter remove rate from Mainframe through Attachmat macrt. if i run macro today for exampl septmber it deletes rates from March, pril May except last business of mnth. i wrote thorugh vb 6 and write the macro in attachmate. i think it is easier. but this function...