Introduction to Velixo's VBA functions

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5: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...

 

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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article