Purpose

Copies the active workbook without Velixo's formulas to a specific location on the disk.

See Introduction to Velixo's VBA functions for general usage information.

Syntax

  objVelixo.CopyWorkbookWithoutFormulas TargetPath

objVelixo A variable that represents an instance of the Velixo VBA functions class.

Parameters

Remarks

Newly created workbook becomes the active workbook.

If Application.DisplayAlerts is set to False, any message boxes will be suppressed. This is especially useful for a fully unattended automation. Once completed, set back DisplayAlerts to True

Pro tip: Macros can be removed from an Excel Macro-Enabled Workbook file (*.xlsm) by providing a TargetPath for a standard Excel Workbook file (*.xlsx).

Example

Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba")

Application.DisplayAlerts = False

velixoObj.CopyWorkbookWithoutFormulas "C:\The\Desired\Path\FileName.xlsx"

Application.ActiveWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True