VBA commands for NX: CopyWorkbookWithoutFormulasAsync

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

Description

Asynchronous command that copies the active workbook without Velixo's formulas to a new Excel workbook.

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

Syntax

CODE

objVelixo.CopyWorkbookWithoutFormulasAsync TargetPath

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

Arguments

Name	Required / Optional	Description
`TargetPath`	Required	The argument is not used by the command and can remain empty: `""` Keeping it in the formula, however, is necessary for the command’s backwards compatibility.

Remarks

The newly created workbook becomes the active workbook.

Example

CODE

Dim velixoObj As Velixo_NX_Tools.VBA
Set velixoObj = CreateObject("Velixo.NX.Tools.Vba")

velixoObj.CopyWorkbookWithoutFormulasAsync ""