Introduction to Velixo's VBA functions
Created by Damien Zwillinger, Modified on Thu, 05 Oct 2023 at 05:56 PM by Gabriel Michaud
Applies to:
- Velixo Classic
- Velixo NX (when used with Excel on Desktop)
Important: Visual Basic for Applications macros are not supported by Excel Online.
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...

Scroll the list and check Velixo Reports. Click OK.

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:

See Visual Basic for Applications Functions Reference for details on each functions.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article