Velixo Reports Pro exposes some of it's features through Visual Basic for Application (Excel's macro language). This enables powerful automation possibilities like automatically distributing a report on a schedule.

In order to get started there is a few things to know:

Prerequisites

  • Velixo Reports Pro version 4.3 and up installed

  • Excel workbook with a connection already set up. (use Connection Manager to add a connection) For fully unattended automation, you will most likely want to use the Save Password feature. (see Connection Editor for more info)

Adding the Reference

Before you can use Velixo's VBA functions in your macros, you need to add a reference to Velixo.VBA object. This step needs to be repeated once for every workbook where you want to use the functions.

To do so, first, press Alt+F11 from an opened Excel workbook to show the Microsoft Visual Basic for Applications window.

Click Tools -> References...

mceclip0.png

Scroll the list and check Velixo Reports. Click OK.

mceclip0.png

How to use Velixo's VBA functions

First declare an object As Velixo_Reports.VBA and use CreateObject to instantiate it.

Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba")

You are ready to use the VBA functions. You can see the available functions with intellisense:

mceclip0.png

See Visual Basic for Applications Functions Reference for details on each functions.

Did this answer your question?