Windows Script Host Error

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Coinadrink
    Visitor
    • Jan 2011
    • 3
    #1

    Windows Script Host Error

    I'm sorry if this has been mentioned before, I did search, but couldn't find anything.

    Today we needed to compare two XLS files, so I tried this out in a demo of BC that I had installed on my system recently. This worked great, so we decided to purchase BC... I upgraded the demo version using the menu option, then entered the licence info.

    But when I tried to compare the files I had been comparing previously... an error message popped up:

    Windows Script Host
    Script: C:\Program Files\Beyond Compare 3\Helpers\XLS_to_CSV_Single.vbs
    Line: 19
    Char: 1
    Error: Object doesn't support this property or method: 'AutomationSecurity'
    Code: 800A01B6
    Source: Microsoft VBScript runtime error

    ...any ideas?

    I hadn't changed the XLS file, since the last time I was working on it and it still opens fine in Excel.
    Tags: None
    • Chris
      Team Scooter
      • Oct 2007
      • 5538
      #2
      Beyond Compare uses a Visual Basic script to open XLS files in Excel, then convert them to CSV to open in the Data Compare.

      The "AutomationSecurity" mentioned is about a setting to disable macros when the files are opened in Excel for the conversion.

      What version of Microsoft Excel do you have on your computer?
      Chris K Scooter Software

        Comment

        • Coinadrink
          Visitor
          • Jan 2011
          • 3
          #3
          It's a bit of an old version on this system I'm afraid.

          Excel 2000 running on XP.

            Comment

            • Aaron
              Team Scooter
              • Oct 2007
              • 16026
              #4
              Hello,

              If you go to our Beyond Compare 3\Helpers directory, you should see a XLS_to_CSV_Single.vbs file used for our Data Compare conversion. Please open and edit this file using Notepad.

              If you comment out 3 lines using the ' character (similar to the lines at the top of the file), does it improve performance for you? The lines are:
              mso = app.AutomationSecurity
              app.AutomationSecurity = msoAutomationSecurityForceDisable

              and

              app.AutomationSecurity = mso
              Aaron P Scooter Software

                Comment

                • Coinadrink
                  Visitor
                  • Jan 2011
                  • 3
                  #5
                  Yep, that fixed it, thanks for your time.

                    Comment

                    • Erik
                      Team Scooter
                      • Oct 2007
                      • 437
                      #6
                      You may run into this problem if you're running Excel 97 or Excel 2000.

                      If so, download the attached file and save it as "XLS_to_CSV_Single.vbs" in the "Helpers" subfolder of your BC3 installation folder.

                      This will be fixed in an upcoming release.
                      Erik Scooter Software

                        Comment

                        Previous template Next
                        Working...