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.
objVelixo - a variable that represents an instance of the Velixo VBA functions class.
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".
Newly created workbook becomes the active workbook.
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
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).
Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba")
Application.DisplayAlerts = False
Application.DisplayAlerts = True