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

    ...LastDay(intOriginYear As Integer, intOriginMonth As Integer, ByVal strEffDate As Date, ByVal InputReadRates, ByVal RevalPriorToDate) As Variant ' ************************************************************************** ' * Checks to see if the date from the file is the last day of the...
  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

    ...Sess0.Screen.Sendkeys("<Tab>LKMN4<Enter>") Sess0.Screen.WaitHostQuiet(g_HostSettleTime) Print #1, InputPriorToDate$ '*********************************************************************** '*Get each currency's date and amount and print to QrtlyRateDate file. *...
  18. swamy567

    exclude last business day

    ...LastDay(intOriginYear As Integer, intOriginMonth As Integer, ByVal strEffDate As Date, ByVal InputRateRead, ByVal RevalPriorToDate) As Variant ' ************************************************************************** ' * Checks to see if the date from the file is the last day of the...
  19. swamy567

    exclude last business day only

    ...LastDay(intOriginYear As Integer, intOriginMonth As Integer, ByVal strEffDate As Date, ByVal InputRateRead, ByVal RevalPriorToDate) As Variant ' ************************************************************************** ' * Checks to see if the date from the file is the last day of the...
  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