Welcome Guest
Log In | Register )
You last visited December 9, 2016, 8:10 pm
All times shown are
Eastern Time (GMT-5:00)

excel

Topic closed. 29 replies. Last post 4 years ago by retxx.

Page 2 of 2
PrintE-mailLink
Avatar
Florida
United States
Member #66575
October 30, 2008
3549 Posts
Offline
Posted: August 10, 2012, 2:00 pm - IP Logged

This highlights the main reason to learn how to write your own stuff.

Then your app can be obscure or old as the hills, and you can still get it to do what you need.

I used to see this problem regularly with people using "inherited" code.

You are so right ,

I may have to start looking at a VBA for Dummies course .

Thanks To everyone who replied

 

I learn even through my mistakes

Carlig

    retxx's avatar - mrthumbs
    BOSTON
    United States
    Member #48
    September 9, 2001
    3594 Posts
    Offline
    Posted: August 10, 2012, 2:16 pm - IP Logged

    replyed to your e-mail. success will wait to hear . shall i delete the one you just sent along with all the others/?

      susscs's avatar - hani
      Michigan
      United States
      Member #89371
      April 6, 2010
      191 Posts
      Offline
      Posted: August 10, 2012, 3:16 pm - IP Logged

      Carli,  Retxx might be able to open it and use in oen office or possilly google docs either would keep the marcos , instead of downloading he could use the file in either place but you would need to upload to google docs.

      He may not bring to to it,

      But he will bring you through it!

        Avatar
        Florida
        United States
        Member #66575
        October 30, 2008
        3549 Posts
        Offline
        Posted: August 10, 2012, 3:21 pm - IP Logged

        Carli,  Retxx might be able to open it and use in oen office or possilly google docs either would keep the marcos , instead of downloading he could use the file in either place but you would need to upload to google docs.

        Thank You susscs

        I honestly wasnt aware that google docs allowed macros, thats good to know.

        Another helpful Lper did Pm me a code solution, so for now at least Rettx is back is business .

        I do appreciate everyones input and advice .

        This was my first attempt at using a macro in a sheet I posted and I should have understood it myself before posting it.

         

        Thank You All

        Carlig

          SergeM's avatar - slow icon.png
          Economy class
          Belgium
          Member #123700
          February 27, 2012
          4035 Posts
          Offline
          Posted: August 10, 2012, 3:37 pm - IP Logged

          @retxx

          I suggest that you buy a new computer, when a good version of Windows 8 comes out and the newer version of MS Office.
          Also you might get a few evening classes of VBA Excel to get a kick start. Teachers can answer questions, books can only be read.

            RJOh's avatar - chipmunk
            mid-Ohio
            United States
            Member #9
            March 24, 2001
            19830 Posts
            Offline
            Posted: August 10, 2012, 5:31 pm - IP Logged

            This highlights the main reason to learn how to write your own stuff.

            Then your app can be obscure or old as the hills, and you can still get it to do what you need.

            I used to see this problem regularly with people using "inherited" code.

            How true, I'm still adding new features to my old GWBasic programs.  Now the only problem I will eventually have they won't run on the newer machines once my XP machines stop working.  I just wished I had invested in a better XP laptop.

             * you don't need to buy more tickets, just buy a winning ticket * 
               
                         Evil Looking       

              Avatar

              United States
              Member #41846
              June 23, 2006
              460 Posts
              Offline
              Posted: August 10, 2012, 6:32 pm - IP Logged

              RJOH  if you can program in GWBasic you can use VBA.  just a few differences and you are there.  I used to do everything in GWBasic, had a little problem with some simple things at first. fellow LP'ers helped.  VBA is easier than GWbasic, 80% or more of the syntax is the same.  getting information in and out is different, but easier once you understand it, and it will work with any version of windows.

                retxx's avatar - mrthumbs
                BOSTON
                United States
                Member #48
                September 9, 2001
                3594 Posts
                Offline
                Posted: August 10, 2012, 8:25 pm - IP Logged

                hi carli its 8:23 pm I just downloaded what you sent it opened and ask to enter a number which I did and click ok next screen came up on line 11774 the number appeared but gave no list of predictions

                  retxx's avatar - mrthumbs
                  BOSTON
                  United States
                  Member #48
                  September 9, 2001
                  3594 Posts
                  Offline
                  Posted: August 10, 2012, 8:33 pm - IP Logged

                  what about that idea by susss to google and try that?
                  Boy we sure are getting  help aren't  we

                    Avatar
                    Florida
                    United States
                    Member #66575
                    October 30, 2008
                    3549 Posts
                    Offline
                    Posted: August 10, 2012, 9:12 pm - IP Logged

                    what about that idea by susss to google and try that?
                    Boy we sure are getting  help aren't  we

                    If you want to try opening in Google, thats up to you. I cant do it for you because of course mine works just fine lol

                    CG

                      RJOh's avatar - chipmunk
                      mid-Ohio
                      United States
                      Member #9
                      March 24, 2001
                      19830 Posts
                      Offline
                      Posted: August 11, 2012, 12:15 am - IP Logged

                      RJOH  if you can program in GWBasic you can use VBA.  just a few differences and you are there.  I used to do everything in GWBasic, had a little problem with some simple things at first. fellow LP'ers helped.  VBA is easier than GWbasic, 80% or more of the syntax is the same.  getting information in and out is different, but easier once you understand it, and it will work with any version of windows.

                      I bought a copy of VB6 some years ago but never got around to learning enough to use it.  Before then I bought a Quick Basic compiler and was learning QB until I learn the QB compiler could compile GWBasic programs.  Even downloaded a copy of JustBasic with its tutorial and thought if I learned it I might buy a copy of Liberty Basic which seems closer to GWBasic than VB.  At my age, it's just easier to go with what I already know until I have to learn a new way to do the same thing.

                       * you don't need to buy more tickets, just buy a winning ticket * 
                         
                                   Evil Looking       

                        retxx's avatar - mrthumbs
                        BOSTON
                        United States
                        Member #48
                        September 9, 2001
                        3594 Posts
                        Offline
                        Posted: August 11, 2012, 11:01 am - IP Logged

                        carli you are not going to believe this but phileight suggested  I change the name of lookuo to another. I did and lo and behold when it ask for a number to enter it prints out the rows and columns to the right that you had sent me. wow wow wow.explain what i get if i enter into draws 2,3,4,5

                          retxx's avatar - mrthumbs
                          BOSTON
                          United States
                          Member #48
                          September 9, 2001
                          3594 Posts
                          Offline
                          Posted: August 11, 2012, 1:27 pm - IP Logged

                          question carli how can we get that list to change to show tiers. Can it be done if I e-mail it to you?

                            Avatar
                            Florida
                            United States
                            Member #66575
                            October 30, 2008
                            3549 Posts
                            Offline
                            Posted: August 11, 2012, 3:06 pm - IP Logged

                            carli you are not going to believe this but phileight suggested  I change the name of lookuo to another. I did and lo and behold when it ask for a number to enter it prints out the rows and columns to the right that you had sent me. wow wow wow.explain what i get if i enter into draws 2,3,4,5

                            Wow, Im so glad She / He was able to resolve it for you .. The only reason I put the extra buttons  2 3 4 etc was if you wanted to do maybe the previous draw also

                            or if you wanted to look up the different permutations like , 123  132  231 213  etc .

                            Where did I get the tiers, you asked ?  By using the Deflate tool on Lottery Post

                             

                            CG

                              retxx's avatar - mrthumbs
                              BOSTON
                              United States
                              Member #48
                              September 9, 2001
                              3594 Posts
                              Offline
                              Posted: August 11, 2012, 4:11 pm - IP Logged

                              carli I seem to have had some luck with the tiers so can you do this for me. i will give you sun mid and eve numbers sun eve. Could you do a combine the 2 for me and post the upper tiers and i will play them for the whole week. Thanks for your help.