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
Comments
0 comments
Please sign in to leave a comment.