1. SUNTRAP SYSTEMS
  2. Excel Diff Help
  3. Menus
  4. Tool


Tool

Compare Current

Selected pages are compared.
Multiple pages are able to be selected by clicking on tabs with holding Ctrl key.

Compare All Pages

All pages within selected Project are compared.
Also, multiple Projects are able to be compared.

Compare Selected Projects

Project/page selection window is displayed when multiple Projects are to be compared simultaneously.


Export Macro code

Excel Diff is not able to directory compare VBA macros included in Excel book. However, this specific functionality will export those macros to compare with other general text application.

Following procedure is needed to activate this functionality. Please do following setting in Excel after closing Excel Diff.

Excel2007

  1. Click the Microsoft Office Button, and then click Excel Options.
  2. Click Trust Center.
  3. Click Trust Center Settings.
  4. Click Macro Settings.
  5. Click to select the Trust access to the VBA project object model check box.
  6. Click OK to close the Excel Options dialog box.

Excel2003

  1. On the Tools menu, point to Macro, and then click Security.
  2. In the Security dialog box, click the Trusted Sources tab.
  3. Select the Trust access to Visual Basic Project check box.
  4. Click OK.


Compare Option

Compare Option is able to be modified.
See “Compare Option” for details.

Application Option

Application Option is able to be modified.
See “Application Option” for details.