[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

RE: Excel diff script

From: Barry Price <barryprice_at_xtra.co.nz>
Date: 2006-06-05 13:31:03 CEST

Peter McNab wrote:
> Suraj Barkale wrote:
>> Hi,
>> I know the Compare side by side function in Excel is not a true
>> diff but it is the closest thing we have got. So here is a script to
>> open two excel files in the compare side by side view. Most of it is
>> copied from scripts supplied with TSVN. I am posting from gmane so I
>> can not attach files. Please saperate the script given below from
>> mail. Thanks & Regards, Suraj
>>
> I tried the diff script on a Win2k box and Excel 97 which produced an
> error. Line: 41
> Char: 1
> Error: Object doesn't support this property or method:
> Windows.CompareSideBySideWith'
> Code: 800A01B6
> Source: Microsoft VBScript runtime error.
>
> I'm VBScript illiterate and don't know if the problem would resolve
> with
> XP or a later version of Excel
> Does the script need a test for Excel version too?
>
> Peter
>
I tried running it on XP with Office XP and found the same result.

Looking at the documentation I find this on MSDN

"Excel Primary Interop Assembly Reference
IWindows.CompareSideBySideWith Method
This method supports the .NET Framework infrastructure and is not
intended to be used directly from your code."

CompareSideBySideWith method is supported by Word but not Excel.

Barry

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tortoisesvn.tigris.org
For additional commands, e-mail: dev-help@tortoisesvn.tigris.org
Received on Mon Jun 5 13:33:27 2006

This is an archived mail posted to the TortoiseSVN Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.