Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. swamy567

    missing lines

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

    missing lines

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

    missing lines

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

    missing lines

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

    missing lines

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

    missing lines

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

    missing lines

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

    dateserial function

    it is working i made mistake
  9. swamy567

    dateserial function

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

    dateserial function

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

    macro inlcude last businessday

    thanks a lot! it is working great.
  12. swamy567

    macro inlcude last businessday

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

    macro inlcude last businessday

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

    macro inlcude last businessday

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

    macro inlcude last businessday

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

    macro inlcude last businessday

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

    macro inlcude last businessday

    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>")...
  18. swamy567

    exclude last business day

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

    exclude last business day only

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

    Exclude last business day of the month

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

Part and Inventory Search

Back
Top