The range of products from our Office VBA Security & Compliance module offers a collection of components and solutions to get a save and transparent use of VBA macros (Virtual Basic for Applications in Microsoft Office) in your company. It also enables a smooth preparation with regard to migration VBA macros for a new Microsoft Office version. Achieved security and transparence supports you to use and control the VBA macros to prepare perspectivly the switch to Microsoft Office 365.
What is Office VBA Security & Compliance
ProWare Solutions GmbH’s Office VBA Security & Compliance product range is a collection of components and solutions that adds important features to Microsoft Office in the use of VBA macros. Many companies use VBA macros in Microsoft Office to provide easy work facilitation for users. But VBA is also still used for business-critical applications. Microsoft’s further development of VBA is also discontinued.
New office applications such as the Office Mobile apps for iOS, Android and Windows Phone, as well as the online versions (Office Online apps) no longer support VBA. However, many companies have lack transparency about the VBA macros in use before possible migration. The Office Telemetry tool provided by Microsoft does not analyze VBA macros. Nor does Microsoft provide effective support to limit new VBA macros without completely stopping them, or to make the use of existing VBA macros safer.
This is where Office VBA Security & Compliance comes in. A collection of components and solutions address Microsoft Office shortfalls in the areas described and add new features.
Components and solutions of Office VBA Security & Compliance
The overview below describes the Office VBA Security & Compliance components you receive depending on the type of licensing.
VBA Access Library
Provides you with an API to access VBA content from Microsoft Office documents even without installing Microsoft Office. Supports, among other things, the search, analysis, unlocking and signing of VBA macros. Can also be used on servers, for example, within your own application. This component is the basis for all other components described here.
Command line tools
Allows you to use all the features contained in the VBA Access Library directly from the Windows command line. For each function, a separate command is included, so that you can call it, for example, within a batch file. For more information, see the Office VBA Security & Compliance Basis package.
PowerShell-Modules
Allows you to use all the features contained in the VBA Access Library directly from the Windows Powershell. For each function, a separate command is included, so you can use it within your own PowerShell automation, for example. For more information, see the package Office VBA Security & Compliance Basis.
COM-Library
Allows you to use the VBA Access Library from programming languages such as PHP. This allows you to integrate the functions contained in the library into your individual intranet portals, for example. For more information, see the Office VBA Security & Compliance Basis package.
VBA Suite
Allows you to use all the functions of the VBA Access Library with an intuitive application. The VBA Suite also allows you to create new analysis via graphic editor. The VBA Suite is ideal for quick entry and quick results, e.g. for an initial assessment. For more information, see the Office VBA Security & Compliance Standard package.
Standard analysis and signing portal
New and modified VBA macros can be checked and released by the employee immediately. Office documents that are included in mail can also be analysed and signed. VBA macros without a signature or with a digital signature that you do not trust will not run. For more information, see the Office VBA Security & Compliance Premium package.
From Office VBA Security & Compliance supported applications
The icons below show the Microsoft Office applications supported by Office VBA Security & Compliance. Please note that most of our components do not require Microsoft Office installation.
Signing of Office files
You can purchase any package we offer with or without an option to sign office files with a digital signature. If you purchase this option, all components allow you to add, review, and remove digital signatures to VBA projects. For example, you can use this to add a new signature to a large number of Office documents or to integrate the signing of documents into your own portal.
In addition to the simple standard algorithm from Microsoft Office (MD5), you can also apply the much safer SHA256 (from Office 2016). All signatures can be provided with a counter signature.
