[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 (extended version)

From: Jared Silva <jayrod_at_gmail.com>
Date: 2007-05-01 00:09:46 CEST

cytrynski@web.de wrote:
>
> I have extended the Excel diff script (.vbs) that was created by Suraj Barkale. In the new version the cells in the first worksheet of workbook 1, that are different to the cells in the first worksheet of workbook 2, are marked in red. Therefore it is much easier to find the differences in the side-by-side view. I have tested the script in Excel 2003 and it works fine. I use conditional formatting to mark the cells that are different. This method is very fast (I tested several ways). The script also works with two Excel workbooks that are dragged&dropped to the script's icon in the Windows Explorer. I hope you enjoy it!
>

I have some concerns with your script updates.

The use of "xObject" in lines 13 and 26 break the script for me.

"Dummy_for_Comparison" should be hidden (Format > Sheet > Hide).

The script update should run on the entire Workbook, not just the first Sheet.

The script update should activate (display) the same Sheet in each file.

The script update changes the base file(s). The file(s) should be
marked as unchanged (saved).

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tortoisesvn.tigris.org
For additional commands, e-mail: users-help@tortoisesvn.tigris.org
Received on Tue May 1 00:09:51 2007

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