Welcome Guest
Log In | Register )
You last visited January 16, 2017, 5:37 am
All times shown are
Eastern Time (GMT-5:00)

T-Lex - Same / Change - Excel File & Master Folder

Topic closed. 54 replies. Last post 11 months ago by zussuz.

Page 3 of 4
52
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Online
Posted: February 17, 2016, 11:29 am - IP Logged

Wednesday Feb 17, 2016

PA530 Treasure Hunt

Excel selections:

TLex Wheel:

Sets:

http://1drv.ms/1QlUVcb

    Avatar
    Horwood NL
    Canada
    Member #70613
    February 6, 2009
    299 Posts
    Offline
    Posted: February 17, 2016, 12:29 pm - IP Logged

    Steve

      The program works great . I have one problem though , when I go to close the program after I make the changes to my game . I get " Changes could not be saved because of a sharing violation" . I removed completely and reinstalled in the T-Lex folder but get the same problem .What am I doing wrong ?

    Thanks  GW

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5396 Posts
      Online
      Posted: February 17, 2016, 12:54 pm - IP Logged

      Steve

        The program works great . I have one problem though , when I go to close the program after I make the changes to my game . I get " Changes could not be saved because of a sharing violation" . I removed completely and reinstalled in the T-Lex folder but get the same problem .What am I doing wrong ?

      Thanks  GW

      What game are are you using in TLex and Excel?

      Is the sharing violation from TLex or Excel?

      May be that both text files for the game your analyzing are opened at the same time which should not be the case.

      I haven't had this error yet. 

      Excel only imports from the Master folder in TLex and not the games folder there should not be a sharing violation.

      TLex only uses the games to place in the Games folder.

      If you could let me know what game I can try the same routine to see if I get the same error.

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5396 Posts
        Online
        Posted: February 17, 2016, 12:57 pm - IP Logged

        Steve

          The program works great . I have one problem though , when I go to close the program after I make the changes to my game . I get " Changes could not be saved because of a sharing violation" . I removed completely and reinstalled in the T-Lex folder but get the same problem .What am I doing wrong ?

        Thanks  GW

        Gwoof,

        Try this and see if this fixes the issue:

        f you are running MS Office 2010then here’s how:

        (Office 2007 also suffers from this same ‘sharing violation’ error.  The 2007 onboard diagnostics   apparently does the same job – I don’t know the actual process though, having converted directly from Office 2003 to 2010)

        Microsoft Office 2010 Users

        1> Select ‘File’ from the Main Menu

        2> Select ‘Info’ from the Sidebar

        2> Click on the 2nd box down ‘Check for Issues’ and select the first option ‘Inspect Document’

        Make sure all the boxes are checked then click ‘inspect’

         

        If it finds an issue, it will ‘Flag’ it for you and give you the option to ‘fix’ the issue.

        It worked for me in a nanosecond and re-inspecting the document found no further problems.

        The document could then be saved and no more annoying ‘sharing violation’ pop-up!

        http://brightgreenfuture.biz/blog/2010/06/21/ms-excel-2010-sharing-violation-easy-fix/

          Avatar
          Horwood NL
          Canada
          Member #70613
          February 6, 2009
          299 Posts
          Offline
          Posted: February 17, 2016, 5:13 pm - IP Logged

          What game are are you using in TLex and Excel?

          Is the sharing violation from TLex or Excel?

          May be that both text files for the game your analyzing are opened at the same time which should not be the case.

          I haven't had this error yet. 

          Excel only imports from the Master folder in TLex and not the games folder there should not be a sharing violation.

          TLex only uses the games to place in the Games folder.

          If you could let me know what game I can try the same routine to see if I get the same error.

          I'm using Atlantic 649 . T-Lex is not opened and yes I'm using the same game there .

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5396 Posts
            Online
            Posted: February 17, 2016, 5:39 pm - IP Logged

            I'm using Atlantic 649 . T-Lex is not opened and yes I'm using the same game there .

            What program caused the sharing violation?

            Excel or TLex program?

              Avatar
              Horwood NL
              Canada
              Member #70613
              February 6, 2009
              299 Posts
              Offline
              Posted: February 17, 2016, 5:47 pm - IP Logged

              T-Lex is not opened when I close and save the excel game  this is what I get    Cannot be saved to "TLeximportDrawsSCv2.xlsm" because of a sharing violation .

                Avatar
                Lyon
                France
                Member #136722
                December 17, 2012
                44 Posts
                Offline
                Posted: February 17, 2016, 5:49 pm - IP Logged

                Good evening

                Just some info: (quite easy problems to handle)

                I change the name of the file so i had to change as well it's name in the macro .

                The saved file is not usable in RL when saved  (problems of spaces before the data)

                Formatting  dates in the addnewdrawing sheet does not work properly (maybe a language mistranslation)

                I replaced one of the line (list) with the French loto as it was not implemented in the main drop down menu.

                For the rest from import to SC it's a very useful piece of art

                Thanks

                  Avatar
                  Horwood NL
                  Canada
                  Member #70613
                  February 6, 2009
                  299 Posts
                  Offline
                  Posted: February 17, 2016, 5:56 pm - IP Logged

                  A further comment....The file you are trying to open '407AAE00' is in a different format than specified by the file extension . Verify that the file is not corrupted and is from a trusted source before opening the file .

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5396 Posts
                    Online
                    Posted: February 17, 2016, 6:20 pm - IP Logged

                    A further comment....The file you are trying to open '407AAE00' is in a different format than specified by the file extension . Verify that the file is not corrupted and is from a trusted source before opening the file .

                    Try downloading the Excel file again.

                    http://1drv.ms/1Qjarf0

                    Let me know if the same error occurs.

                      bootleg233's avatar - Lottery-034.jpg
                      Tn
                      United States
                      Member #54963
                      September 4, 2007
                      1166 Posts
                      Offline
                      Posted: February 17, 2016, 6:55 pm - IP Logged

                      winsum is there some reason that the multi-state powerball 569 and 1to26 file dont show in the dropdown box in the excel spreadsheet? Not sure if ive done something wrong or what!! All I see are the others like 5/59 1-35!

                      WHEN IT FEELS THE WHOLE WORLD SUCKS!

                      RELAX.........IT'S ONLY GRAVITY Big Smile

                      I think I can I think I can!!!!

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5396 Posts
                        Online
                        Posted: February 17, 2016, 7:15 pm - IP Logged

                        winsum is there some reason that the multi-state powerball 569 and 1to26 file dont show in the dropdown box in the excel spreadsheet? Not sure if ive done something wrong or what!! All I see are the others like 5/59 1-35!

                        I corrected the Powerball game

                        New link:

                        http://1drv.ms/24b6q0q

                        I had the older folder listed.

                        These are listed as MS or Multi-State Games

                        Poserball and MegaMillions should be there.

                        Let me know if any other errors...

                          bootleg233's avatar - Lottery-034.jpg
                          Tn
                          United States
                          Member #54963
                          September 4, 2007
                          1166 Posts
                          Offline
                          Posted: February 17, 2016, 7:21 pm - IP Logged

                          I corrected the Powerball game

                          New link:

                          http://1drv.ms/24b6q0q

                          I had the older folder listed.

                          These are listed as MS or Multi-State Games

                          Poserball and MegaMillions should be there.

                          Let me know if any other errors...

                          THANK YOU very much steve!!!!! Im indebted! You are outstanding!

                          WHEN IT FEELS THE WHOLE WORLD SUCKS!

                          RELAX.........IT'S ONLY GRAVITY Big Smile

                          I think I can I think I can!!!!

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5396 Posts
                            Online
                            Posted: February 17, 2016, 7:25 pm - IP Logged

                            My Powerball Lexi Picks

                            Lexi Set 1 = 0-3-0-6-1-5-6-1

                            Lexi Set 2 = 0-2-3-9-4-7-8-2

                            If someone would like to wheel each of these and post them....

                            Thanks

                              Avatar
                              Horwood NL
                              Canada
                              Member #70613
                              February 6, 2009
                              299 Posts
                              Offline
                              Posted: February 17, 2016, 7:51 pm - IP Logged

                              Try downloading the Excel file again.

                              http://1drv.ms/1Qjarf0

                              Let me know if the same error occurs.

                              Removed all old installs Downloaded and reinstalled .

                              Now I get  'TLeximportDrawsSCv2.xlsm is locked for editing by 'another user'

                              Open 'Read-Only' or click 'Notify' to open read-only and receive notification when the document is no longer in use.