VBA commands for NX: RunDistributionListAsync

Visual Basic for Applications macros are supported in Excel Desktop for Windows only.

Description

Asynchronous command that distributes the report using the provided distribution list worksheet. This is equivalent to using the "Distribute All" button from the toolbar.

See Introduction to Velixo NX VBA commands for general usage information.

Syntax

CODE

objVelixo.RunDistributionListAsync Worksheet

objVelixo - A variable that represents an instance of the Velixo_NX_Tools.Vba command class.

Arguments

Name	Required / Optional	Description
`Worksheet`	Required	Excel.Worksheet value that provides the Distribution List worksheet to act upon.

When a Distribution List is used with a report containing pivot tables, pivot tables are not automatically refreshed as part of the Distribution process; you need to enable this explicitly. For more information, see the Distribution List article.

Example

CODE

Dim velixoObj As Velixo_NX_Tools.VBA
Dim distributionWorksheet As Excel.Worksheet
Dim currentWorkbook As Excel.Workbook

Set velixoObj = CreateObject("Velixo.NX.Tools.Vba")

Set currentWorkbook = Application.ActiveWorkbook
Set distributionWorksheet = currentWorkbook.Worksheets("Distribution List")

velixoObj.RunDistributionListAsync distributionWorksheet