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

Name

Description

TargetPath

Required. String value that provides the full destination file path, including extension. If file already exists it will be overwritten.

Supported extensions: ".xlsx", ".xls", ".xlsm", ".xlsb".

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