What is Office VBA Security & Compliance Basis

 

Our basic package is the ideal entry point for small businesses or developers of their own solutions. With the components included, you can start instantly using any command line (command line or PowerShell), or integrate the features of the VBA Access Library included in the package into your proprietary applications.

Installing Microsoft Office is not required, you can use all components on clients and server operating systems in active user sessions and unattended (TimerJobs, application backends).

 

The high performance of the VBA Access Library allows a very high speed of more than 1,000 office documents per minute (reading) and 100 Office documents per minute (writing, e.g. signing).

Included in the basic package are the following components:

  • VBA Access Library
  • Command line tools
  • PowerShell modules
  • COM-Library

System requirements

Conditions
Installation required:no
Microsoft Office required:no
Network connection required:no
.NET Version:4.6 or higher
Operating system:Windows Server 2008 or higher (Server), Windows Vista SP1 or higher (Client)

What does VBA Access Library include

The Access Library is the central library for accessing VBA macros. This can be used to create your own programs which treat VBA macros.

What does commend line tools include

The command line tools contains a command for one of the main functions of the VBA Access Library. This allows you to analyze, browse, sign * and unlock Office documents. The command line tools are therefore great for automating operations in older scripts (batch files).

 

Application example:

To sign a document, f.e. use the following command:

vbasign "c:office-dateien" -s -a "CN=proWare" -o

Explanation: With vbasign, choose the VBA Access Library’s Signing feature. All office files are signed in the local directory “c:office files.” With the-s parameter, you specify that sub-directories should also be taken into account. With-a, you specify which certificate  is to be used. In this example, the certificate is installed in the certificate memory of the operating computer. With-o, you specify that possible existing signatures should be overwritten. You can get detailed help with the respective commands by specifying the parameter-?.

vbasign -?

What does powershell-module include

Using the PowerShell module, you can make all the main features of the VBA Access Library available in your PowerShell console or your own PowerShell script. As with the command line tools, you can analyze, browse, sign * and unlock Office documents. The PowerShell module is ideal for modern scripts or use by administrators (e.g. as part of user support).

 

Application example

To sign a document, f.e. use the following command:

Import-Module OVSCModule.dll
Add-VBACertificate -File "c:office-dateienMyDocument.docm" -CertificateSubject "CN=proWare" -Overwrite $true

Explanation: With Add-VBACertificate, select the “Signing” function of the VBA Access Library. The file “c:office-fileienMyDocument.docm” is signed. With the parameter-CertificateSubject, you select the certificate. In this example, the certificate is installed in the certificate memory of the operating computer. With the-Overwrite parameter, you specify that any signatures that may exist should be overwritten. You can get detailed help with each command by calling via the PowerShell command help.

help Add-VBACertificate

What does COM-Library include

The COM Library encapsulates the main functionalities of the VBA Library.

Download area

XML scheme analysis definitions: https://proware-solutions.de/analysisdefinition/ 

Try online!

New! 

Test a selection of our product features online.

Right here:

Start online demo…

Your contact partner

Alexander Petzelt

Managing Director

Tel: + 49 (0911) 955 10 884

alexander.petzelt@proware-solutions.de