Velixo.VBA object available on Velixo NX?

Hi Royce -

I would suggest working with Velixo Tech Support to figure out why your distribution list is having issues.  

As mentioned, Microsoft does not supply an interface for accessing VBA from within office.js applications (such as Velixo NX).  As a result, VBA is only usable with Velixo Classic.

It is very similar but I am having problems with the distribution tool running.   It ran for over 10 minutes yesterday and did not produce a report and generated no error messages.

I am using the existing VBA from Sage 100 intelligence so If I can get the VBA to work,  I would not have to re-create anything.

Thanks, Royce.

So that we have a fuller picture, how does what you are attempting to do differ from the Distribution List feature?

Distribution List : Velixo Help Center 

Installing the Velixo NX Distribution Agent : Velixo Help Center 

Gabriel,

I am using VBA to change report parameters, calculate the report and then print to pdf.  The VBA crashes or produce invalid results because Velixo has not finished calculating before the VBA executes.

Thanks for the help and hope this helps.

Royce,

What Harry indicated above is accurate, however depending on what you're trying to achieve with your VBA command after recalculation there might be alternative ways to achieve the same result.

Can you share, at a high-level, what the VBA macro is supposed to do after the worksheet has recalculated?

Microsoft provides the Office JavaScript API ("office.js") interface for new Excel add-ins.  This technology offers increased security and multi-platform support.  At this point in time, Microsoft does not support a method of accessing Excel Visual Basic for Applications (VBA) from within office.js.

Velixo is working on developing new solutions to provide functionality that - in the past (with the older style add-in Velixo Classic) - was accomplished through the use of VBA.  You'll want to work with Velixo Support to define your requirements, so that they can be considered when developing those new solutions.