Windows Script Host Error

[Coinadrink]

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.

[Chris]

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?

[Coinadrink]

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

Excel 2000 running on XP.

[Aaron]

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

[Coinadrink]

Yep, that fixed it, thanks for your time.

[Erik]

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.