Trace Id is missing

Maximize the everyday with Microsoft 365

Get online protection, secure cloud storage, and innovative apps designed to fit your needs—all in one plan.
A young woman works on a Surface laptop while Microsoft 365 App icons whirl around her head.

Readiness Toolkit for Office add-ins and VBA [Deprecated]

The Readiness Toolkit for Office add-ins and VBA helps you identify compatibility issues with your Microsoft Visual Basic for Applications (VBA) macros and your installed add-ins. Use this tool to inspect VBA macro code and get readiness information for installed Office add-ins.

Important! Selecting a language below will dynamically change the complete page content to that language.

Download
  • Version:

    1.2.23020

    Date Published:

    1/25/2023

    File Name:

    ReadinessToolkitForOffice_1.2.23020.msi

    File Size:

    8.3 MB

    Note: This toolkit is deprecated and will be retired in March 2024. For additional information, see the Office Readiness Toolkit retirement notes.

    The Readiness Toolkit for Office add-ins and VBA is designed to help organizations identify documents that contain VBA macros, assess the compatibility of those macros with Office 365 ProPlus, and provide add-in readiness information for Office add-ins.

    The tool does not repair or fix code. It analyzes Office documents and provides an Excel report detailing their compatibility and readiness to move to an Office 365 ProPlus environment.

    This tool checks compatibility with Office 365 ProPlus for code written for Word, Excel, PowerPoint, Access, Project, Publisher, Outlook and Visio for the following versions of Office:

    • Microsoft Office 2016
    • Microsoft Office 2013
    • Microsoft Office 2010
    • Microsoft Office 2007
    • Microsoft Office 2003

    Release History

    Version 1.0
    Initial release on September 29, 2017.

    Version 1.1.17353
    Changes December 21st, 2017:
    • Improved parsing and pattern matching of VBA code.
    • Improved performance and scale of Readiness Report generated from the Readiness Toolkit.
    • New “Adopted version available” adoption status category to highlight add-ins identified that have a known version to be working in Office 365 ProPlus.
    • Introduced the ability to identify documents that use templates and determine the readiness of templates identified by the Readiness Toolkit.
    • Improved identification of files that contain macros.
    • New file hash to highlight unique files.
    • Improved VBA project hash to better identify unique macros.
    • Fixed macro error “1004” experienced by some users in the Readiness Report.
    • Fixed report writing failures when generating consolidated reports.
    • Improved logging:
    • Log correct toolkit version number.
    • Log the correlation ID into the .log file.
    • Update the correlation ID for each new scan in the same session (while leaving session ID the same) to improve error reporting.


    Version 1.1.18079
    Changes March 20, 2018:
    • Added detection of ODBC use within Office documents.
    • Changed storage format of VBA scan information from TSV to JSON files.
    • Added more code rules to highlight potential compatibility issues with VBA code.
    • Add ability to send Microsoft information about errors encountered in creating a readiness report.
    • Fixed documents incorrectly flagged as “VBA syntax error”.
    • Fixed out of memory exceptions when aggregating large datasets.


    Version 1.1.18095
    Changes April 05, 2018:
    • Fixed issue when scanning VBA encoded in non-UTF8 scripts.
    • Updated link in report error message.


    Version 1.1.18122
    Changes May 04, 2018:
    • Add capability to assign up to 4 custom labels to allow filtering of reports by, for example, department or geographic region.
    • Fixed an issue where crash was encountered by some users while scanning Access databases.
    • Fixed an issue where some files are incorrectly classified as “Inaccessible” on the report overview.
    • Fixed an issue where 64-bit specific rules are given the wrong severity in the 32-bit report.
    • Fixed an issue scanning certain folder paths on command line.
    • Fixed an issue when scanning folder paths greater than 260 characters.


    Version 1.2.18243
    Changes September 06, 2018:
    • New add-in usage report to allow you to identify most used Office add-ins.
    • New feature to conceal file names and paths for added privacy.
    • New option to identify documents that contain Silverlight, Shockwave or Flash controls.
    • New Readiness Toolkit update availability notifications.
    • Improved rule matching to reduce false positives, including application specific rules.
    • Fixed encoding issues with JSON files generated from Readiness Toolkit.
    • Fixed alt text accessibility issues with the Readiness Report.
    • Fixed issue where roaming MRU entries were not being captured.
    • Fixed error when loading report without any VBA or add-in information.
    • Removed BIN file scanning to reduce number of reported inaccessible files.
    • Minor updates and improvements to Readiness Report.


    Version 1.2.18353.6
    Changes January 08, 2019:
    • Added a new filtering option in some reports to only display differences between the version of Office you have installed and Office 365 ProPlus.
    • Added support for additional Visio extensions (".vst", ".vstx", ".vstm", ".vss", ".vssx").
    • Fixed an issue where usage dates were displayed incorrectly.
    • Fixed an issue where certain scenarios were resulting in Out Of Memory exceptions.
    • Fixed an issue where after an unsuccessful scan, the tool would report subsequent scans as also having failed.


    Version 1.2.19029
    Changes February 04, 2019:
    • New device readiness report that highlights devices where Office 365 ProPlus can be deployed to with high confidence.
    • Improved messaging in readiness report generated from Office Telemetry Dashboard data when there is no add-in information in the database.
    • Fixed an issue in the readiness report where it returned an exception if there are no VBA results.
    • Fixed an issue with the 64-bit filtering feature in the readiness report.


    Version 1.2.19059
    Changes March 04, 2019:
    • Fixed an issue where the Readiness Toolkit reports an error has occurred for large scans.
    • Fixed an issue with Office Telemetry Dashboard connection failing when SQL Server credentials are used.
    • Added ability to export results to SQL Server by using the command line.


    Version 1.2.19098
    Changes April 08, 2019:
    • New feature to export results to SQL Server within the UI and view in PowerBI.
    • Added more debug information to the Excel report error dialog.
    • Fixed a bug where null results caused SQL export scenario to fail.
    • Other updates and improvements to SQL export process.
    • Fixed an issue where the shortcut will attempt to call the MSI for non admins.
    • Updates to method for retrieving the list of add-ins.
    • Fixed an issue causing repeated traversal of failing files.
    • Fixed an issue where different cases in file names caused the files to be counted multiple times.
    • Fixed missing hyperlink for the “Scan all office documents to detect Silverlight or Flash controls” text.
    • Fixed an issue where in some scenarios the usage agent was causing Outlook to crash.


    Version 1.2.19120
    Changes May 09, 2019:
    • Fixed issue where a crash occurred if exporting to SQL Server and the Power BI report couldn’t be found.
    • Updated logging behaviour so the VBA summary log file is only written when in debug mode.


    Version 1.2.19140
    Changes May 21, 2019:
    • Add a tool update status message in the Office Telemetry Dashboard scan scenario.
    • Fix a disappearing filter in the Excel report.
    • Improve concealing of file paths to include path of VBA modules as well as documents.
    • Improve logging of detected add-ins.


    Version 1.2.19163
    Changes June 20, 2019:
    • Add an additional log file, which only contains troubleshooting information to help debug issues.
    • Improve logging of detected add-ins.
    • Minor bug fixes.


    Version 1.2.19184
    Changes July 4, 2019:
    • Removed the requirement to install the Readiness Toolkit on the target device for running MRU scan.


    Version 1.2.19231
    Changes August 22, 2019:
    • Update the error message displayed when a user attempts to use data in their Office Telemetry Dashboard that’s older than 90 days.
    • Update the error message when the readiness toolkit is unable to reach the relevant web service to obtain add-in statuses.


    Version 1.2.19339
    Changes December 05, 2019:
    • Update the security layer model to TLS 1.2 which is used to connect to the necessary services to run the toolkit.
    • Update the minimum .NET Framework to 4.7.2.
    • Fix 2 accessibility issues.
    • Remove the reference to ReadyforWindows.com in the Excel report.
    • Improve the speed of the Excel report generation when obfuscation is enabled by the user.


    Version 1.2.20070
    Changes March 18, 2020:
    • Fix an issue where generating multiple reports without closing the toolkit causes an error.
    • Fix an issue with the column order in the optional Power BI report.
    • Updates to support Azure Active Directory (AAD) users.


    Version 1.2.20108
    Changes April 21, 2020:
    • Fix an issue with the Toolkit log files.
    • Fix an out of memory issue in parsing intermediate files.
    • Updates to support local installs of VSTO Add-Ins.
    • Updates to support product branding changes.


    Version 1.2.20276
    Changes October 6, 2020:
    • Fixed an issue with counting of Add-Ins.
    • Updates to improve accessibility.
    • Updates to improve security.


    Version 1.2.21067
    Changes March 19, 2021:
    • Added the ability to scan VBA macros for signatures.


    Version 1.2.22041
    Changes February 14, 2022:
    • Update to improve security.
    • Update to improve file scanning capabilities.


    Version 1.2.22068
    Changes March 28th, 2022:
    • Update to improve security.


    Version 1.2.22161
    Changes June 13th, 2022:
    • Added the ability to measure the potential impact of blocking macros from the internet


    Version 1.2.22272
    Changes September 30th, 2022:
    • Update to improve accessibility
    • Update to improve performance when scanning folders


    Version 1.2.22335
    Changes December 6th, 2022:
    • Update to improve accessibility


    Version 1.2.23020
    Changes January 24th, 2023:
    • Update to improve accessibility
    • Update to improve security


  • Supported Operating Systems

    Windows Server 2016, Windows 10, Windows 7 Service Pack 1, Windows Server 2012 R2, Windows Server 2008 R2, Windows Server 2012, Windows 8.1

    In addition, you must have the following applications installed:
    • Microsoft .NET Framework 4.7.2 or later

    To view the final readiness report, you will need Office 2010 or above.

  • Install Instructions
    1. Download the file and run it to start the setup program.
    2. Follow the instructions on the screen to complete the installation.

    Instructions for use:
    For instructions, see Use the Readiness Toolkit for Office add-ins and VBA to assess application compatibility for Microsoft 365 Apps

    Related Resources
    Deployment Guide for Microsoft 365 Apps
    Microsoft 365 Apps Community
    Office Dev Center

Follow Microsoft