Announcement

Collapse
No announcement yet.

Windows Script Host Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #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


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

      Excel 2000 running on XP.

      Comment


      • #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


        • #5
          Yep, that fixed it, thanks for your time.

          Comment


          • #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

            Working...
            X