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

excel

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

Page 1 of 2
PrintE-mailLink
retxx's avatar - mrthumbs
BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
Posted: August 10, 2012, 8:49 am - IP Logged

Todd. need help. I downloaded a program from carlig with macros enabled. When i went to enter a past draw a popup appeared that said compile error argument not found. I do not know how to fix it. i hope you can help. thanks

    Todd's avatar - Cylon 2.gif
    Chief Bottle Washer
    New Jersey
    United States
    Member #1
    May 31, 2000
    23273 Posts
    Online
    Posted: August 10, 2012, 9:10 am - IP Logged

    Todd. need help. I downloaded a program from carlig with macros enabled. When i went to enter a past draw a popup appeared that said compile error argument not found. I do not know how to fix it. i hope you can help. thanks

    Sounds like an error in the Macro program code, or else you are using an older version of Excel than what it was designed for.  You'd have to ask CarliG.

     

    Check the State Lottery Report Card
    What grade did your lottery earn?

     

    Sign the Petition for True Lottery Drawings
    Help eliminate computerized drawings!

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

      Sounds like an error in the Macro program code, or else you are using an older version of Excel than what it was designed for.  You'd have to ask CarliG.

      Todd,

      Trust me , he has asked Carlig  lol

      He is using Excel 2000  and I have shared this same exact sheet with several other people and none of them is having a problem with it.

      I am not experienced enough to be able analyze and tell him why he may be having an issue if others arent .

      It is code that I found on an open excel help forum and then altered to make it do what I wanted. But other than that, Im pretty much excel illiterate.

      Carlig

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

        Todd,

        Trust me , he has asked Carlig  lol

        He is using Excel 2000  and I have shared this same exact sheet with several other people and none of them is having a problem with it.

        I am not experienced enough to be able analyze and tell him why he may be having an issue if others arent .

        It is code that I found on an open excel help forum and then altered to make it do what I wanted. But other than that, Im pretty much excel illiterate.

        Carlig

        In the VBE use F8 to run the macro line by line. Fix the errors.

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

          In the VBE use F8 to run the macro line by line. Fix the errors.

          On my end there are no errors, so I dont know what im looking for to change for whatever error he is having .

          He says its a compilation error, thats all I know .

          The code looks very basic to me.

           

          CG

            Todd's avatar - Cylon 2.gif
            Chief Bottle Washer
            New Jersey
            United States
            Member #1
            May 31, 2000
            23273 Posts
            Online
            Posted: August 10, 2012, 10:20 am - IP Logged

            Todd,

            Trust me , he has asked Carlig  lol

            He is using Excel 2000  and I have shared this same exact sheet with several other people and none of them is having a problem with it.

            I am not experienced enough to be able analyze and tell him why he may be having an issue if others arent .

            It is code that I found on an open excel help forum and then altered to make it do what I wanted. But other than that, Im pretty much excel illiterate.

            Carlig

            What version of Excel are you using?

             

            Check the State Lottery Report Card
            What grade did your lottery earn?

             

            Sign the Petition for True Lottery Drawings
            Help eliminate computerized drawings!

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

              What version of Excel are you using?

              Thanks Todd

              I have 2007

              Rettx is using 2000

               

              CG

                swngnblues's avatar - abstract
                Greensboro
                United States
                Member #109769
                April 19, 2011
                2111 Posts
                Offline
                Posted: August 10, 2012, 11:52 am - IP Logged

                Thanks Todd

                I have 2007

                Rettx is using 2000

                 

                CG

                Is the file saved as .xls or .xlsx? 

                Excel 2000 is pretty far back and there are some known VB issues with older versions of Excel with newer (2007 and 2010 specifically) files.  Depending on where you got the piece of code, it may only be using newer functions that were developed for Office 2003 or even 2007. 

                AFAIK, MS has dropped support/service packs for Office versions prior to 2007, but it's possible that there are some add-ins available that may enhance the support for retxx's verson of Excel.

                Retxx, you may want to try installing LibreOffice - it's an opensource (free) version of office tools that may have some support for the coding in the spreadsheet.

                Please do not PM me asking for "special tips" - everything I'm willing to disclose is in a public thread somewhere.

                  Todd's avatar - Cylon 2.gif
                  Chief Bottle Washer
                  New Jersey
                  United States
                  Member #1
                  May 31, 2000
                  23273 Posts
                  Online
                  Posted: August 10, 2012, 12:12 pm - IP Logged

                  Thanks Todd

                  I have 2007

                  Rettx is using 2000

                   

                  CG

                  That's most likely the problem.  The spreadsheet is probably using a function that was not available in the 2000 version.

                   

                  Check the State Lottery Report Card
                  What grade did your lottery earn?

                   

                  Sign the Petition for True Lottery Drawings
                  Help eliminate computerized drawings!

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

                    That's most likely the problem.  The spreadsheet is probably using a function that was not available in the 2000 version.

                    Thanks Todd

                    I will make sure Rettx sees this

                     

                    Carlig

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

                      Is the file saved as .xls or .xlsx? 

                      Excel 2000 is pretty far back and there are some known VB issues with older versions of Excel with newer (2007 and 2010 specifically) files.  Depending on where you got the piece of code, it may only be using newer functions that were developed for Office 2003 or even 2007. 

                      AFAIK, MS has dropped support/service packs for Office versions prior to 2007, but it's possible that there are some add-ins available that may enhance the support for retxx's verson of Excel.

                      Retxx, you may want to try installing LibreOffice - it's an opensource (free) version of office tools that may have some support for the coding in the spreadsheet.

                      Thanks swingblues

                      I had saved it as .xls  because I thought that had the best chance of being compatible .

                      I got the code off an excel help forum , other than that, not a clue. I looked at the code and to me it looked pretty basic. but then again, I dont really know VBA

                       

                      Thanks for replying

                      Carlig

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

                        wow getting some help here. maybe there is an answer carli. keep digging. we know it works.

                          Todd's avatar - Cylon 2.gif
                          Chief Bottle Washer
                          New Jersey
                          United States
                          Member #1
                          May 31, 2000
                          23273 Posts
                          Online
                          Posted: August 10, 2012, 1:38 pm - IP Logged

                          wow getting some help here. maybe there is an answer carli. keep digging. we know it works.

                          I think we already have the answer:  your version of Excel is too old.

                           

                          Check the State Lottery Report Card
                          What grade did your lottery earn?

                           

                          Sign the Petition for True Lottery Drawings
                          Help eliminate computerized drawings!

                            lottoburg's avatar - wiggle
                            NYC
                            United States
                            Member #54483
                            August 20, 2007
                            886 Posts
                            Offline
                            Posted: August 10, 2012, 1:54 pm - IP Logged

                            I think we already have the answer:  your version of Excel is too old.

                            I Agree!Wink

                              time*treat's avatar - radar

                              United States
                              Member #13130
                              March 30, 2005
                              2171 Posts
                              Offline
                              Posted: August 10, 2012, 1:56 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.

                              In neo-conned Amerika, bank robs you.
                              Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.