Compare Excel Files

Compare XLS Workbooks With Code Example

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

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

Compare Excel Files Payment Problems/Options Download Demo Purchase MUST be made via this site for the free software shown below.

Number of licenses/units	Individual price
1-4	USD: 69.00
5-9	USD: 49.00
From10	USD: 43.00

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $65.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Add-ins Index & Compare Excel Workbooks & Compare Suite or, All Software

Instant Download and Money Back Guarantee on Most Software

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

FREE Download!

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

FREE Excel Help