# Velixo.VBA object available on Velixo NX?

**URL:** <https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78>\
**Category:** General\
**Created:** [October 22, 2024, 8:45pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78 "2024-10-22T20:45:40Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Royce\_Pruitt](https://community.velixo.com/letter_avatar_proxy/v4/letter/r/a698b9/32.png) [@Royce\_Pruitt](https://community.velixo.com/u/Royce_Pruitt)\
**Post date:** [October 22, 2024, 8:45pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78/1 "2024-10-22T20:45:40Z")

</div>

Does anyone know if the Velixo VBA object is available on Velixo NX? If so, does anyone know how to install it?

I am trying to pause my VBA code so that Velixo will calc before it proceeds and found a VBA command that will do this but it require the Velixo object to be installed.

=== Please type above and preserve the below information ===  
Name: Royce Pruitt  
Excel version: PC 16.0.18025.20160  
Connection: collierfoodsCRG

---

<div class="post-metadata">

**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\
**Post date:** [October 22, 2024, 9:31pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78/2 "2024-10-22T21:31:09Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\
**Post date:** [October 22, 2024, 9:53pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78/3 "2024-10-22T21:53:14Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Royce\_Pruitt](https://community.velixo.com/letter_avatar_proxy/v4/letter/r/a698b9/32.png) [@Royce\_Pruitt](https://community.velixo.com/u/Royce_Pruitt)\
**Post date:** [October 23, 2024, 12:24pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78/4 "2024-10-23T12:24:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\
**Post date:** [October 23, 2024, 3:36pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78/5 "2024-10-23T15:36:17Z")

</div>

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](https://help.velixo.com/support/solutions/articles/153000018591-distribution-list)

[Installing the Velixo NX Distribution Agent : Velixo Help Center](https://help.velixo.com/support/solutions/articles/153000168531-installing-the-velixo-nx-distribution-agent)

---

<div class="post-metadata">

**Author:** ![Royce\_Pruitt](https://community.velixo.com/letter_avatar_proxy/v4/letter/r/a698b9/32.png) [@Royce\_Pruitt](https://community.velixo.com/u/Royce_Pruitt)\
**Post date:** [October 24, 2024, 2:00pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78/6 "2024-10-24T14:00:26Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\
**Post date:** [October 24, 2024, 4:01pm UTC](https://community.velixo.com/t/velixo-vba-object-available-on-velixo-nx/78/7 "2024-10-24T16:01:28Z")

</div>

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.
