Compare Excel Files

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Compare XLS Workbooks With Code Example

Buy Today, send us your order ID, and claim over $70.00 worth of FREE software

Compare Excel Files Start

Comparing Excel files using code

You can go further in automating the process of Comparing Excel files because Compare Excel Files is an ActiveX program. By pressing the [Macro]-button you get the code which matches the current settings and a short instructions how to include the code in your Visual Basic or Office (VBA, Excel, Access) application.

Optional example code obtained using the [Macro]-button

'This macro code can be called from your Visual Basic or Office (VBA, Excel, Access) application.

'This way you can use the ExcelCompare program as an Excel Comparison server / library to

'integrate comparison with your program's process.

'1. New or Open module in your application

'2. Past this code into the module

'3. Set a reference to xlcompare.exe

Sub ExcelCompare1()

Dim Success As xlCompare.ecResult

    Dim oXlCompare As xlCompare.Compare

    Set oXlCompare = New xlCompare.Compare

    Success = oXlCompare.Execute(File1:="C:\projects\agora\VB6\code\ExcelCompare\TestFiles\FileNew.xls", _

            File2:="C:\projects\agora\VB6\code\ExcelCompare\TestFiles\FilePreviousDiffRowOrder.xls", _

            Worksheet1:="SheetWithTable", _

            Worksheet2:="SheetWithTable", _

            Start Row:=1, _

            IdentifyingColumns:="1", _

            Start Column:="1", _

            EndColumn:="77", _

            PrintTo:="C:\projects\agora\VB6\code\ExcelCompare\Reports\compare tables analysis.htm", _

            OpenReport:=True, _

            PrintVisualizedTo:="C:\projects\agora\VB6\code\ExcelCompare\Reports\compare tables visualisation.htm", _

            OpenVisualized:=True)

    Select Case Success

    Case ecResultNormal

        MsgBox "Comparison is finished successfully.", vbInformation

    Case ecResultEqual

        MsgBox "No different.", vbInformation

    Case ecResultCancel

        MsgBox "Comparison is canceled.", vbInformation

    Case ecResultError

        MsgBox "Error during execution of comparison.", vbCritical

    End Select

    Set oXlCompare = Nothing

End Sub

Compare Excel Files Start

Compare Excel Files Examples :

Comparing tables in worksheets
Comparing Excel files using code
Comparing Excel files using ranges
Comparing Excel worksheets
Comparing multiple ranges in Excel worksheets

Download Demo

Compare Excel Files <<Click to see price Secure Payment Options

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft