VBA commands for NX: WritebackWorksheetAsync
Visual Basic for Applications macros are supported in Excel Desktop for Windows only.
Description
Asynchronous command that imports the provided Writeback worksheet.
See Introduction to Velixo NX VBA commands for general usage information.
Syntax
objVelixo.WritebackWorksheetAsync Worksheet
objVelixo - A variable that represents an instance of the Velixo_NX_Tools.Vba command class.
Arguments
Name | Required / Optional | Description |
|---|---|---|
| Required | Excel.Worksheet value that provides the Writeback worksheet to import. |
Example
Dim velixoObj As Velixo_NX_Tools.VBA
Dim WritebackWorksheet As Excel.Worksheet
Dim currentWorkbook As Excel.Workbook
Set velixoObj = CreateObject("Velixo.NX.Tools.Vba")
Application.DisplayAlerts = False
Set currentWorkbook = Application.ActiveWorkbook
Set WritebackWorksheet = currentWorkbook.Worksheets("Writeback")
velixoObj.WritebackWorksheetAsync WritebackWorksheet
Application.DisplayAlerts = True