IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools
Compare | Modules menu command
Use this command to compare 2 Visual Basic Modules.
When you compare 2 workbooks, xlCompare processes all Visual Basic modules, and compare them. But you may want to compare only 2 modules from the both workbooks.
Or 2 modules from the same workbook. If you are VBA Code developer - this is common tasks.
This command allows you to compare 2 modules, which are opened on the screen.
Before using this command you should switch to the VBA Module view:
After pressing VB Project button, it became highlighted with green color, and xlCompare displays modules in the Visual Basic Projects.
This is required. xlCompare should know which modules are selected.
Also, you should select 2 different modules. If the same module is selected on the both panes - there is nothing to process.
Results of the comparison are shown exactly in the same form as for the worksheet comparison - in the Difference Browser window:
When you have comparison results on the screen you can merge Visual Basic code between 2 modules.