VBA: CopyWorkbookWithoutFormulas

Visual Basic for Applications macros are not supported by Excel Online.

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

CODE

objVelixo.CopyWorkbookWithoutFormulas TargetPath

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

Arguments

Name	Description
`TargetPath`	Required. A String value that provides the full destination file path, including extension. If the 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 DisplayAlerts back 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

CODE

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