Important! Selecting a language below will dynamically change the complete page content to that language.
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.
ReadinessToolkitForOffice_1.2.23020.msi
-
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 System
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.
