Recent content by swamy567

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