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.
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".
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).
Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba")
Application.DisplayAlerts = False
Application.DisplayAlerts = True