Purpose
Imports the provided Budget Writeback worksheet.
See Introduction to Velixo's VBA functions for general usage information.
Syntax
objVelixo.ImportBudgetWritebackSheet Worksheet
objVelixo A variable that represents an instance of the Velixo VBA functions class.
Parameters
Name | Description |
Worksheet | Required. Excel.Worksheet value that provides the Budget Writeback worksheet to import. |
Remarks
If Application.DisplayAlerts is set to False, any message boxes will be suppressed and warnings and errors will be returned as exceptions. This is especially useful for a fully unattended automation. Once completed, set back DisplayAlerts to True
Example
Dim velixoObj As Velixo_Reports.VBA
Dim budgetWritebackWorksheet As Excel.Worksheet
Dim currentWorkbook As Excel.Workbook
Set velixoObj = CreateObject("Velixo.Reports.Vba")
Application.DisplayAlerts = False
Set currentWorkbook = Application.ActiveWorkbook
Set budgetWritebackWorksheet = currentWorkbook.Worksheets("Budget Writeback")
velixoObj.ImportBudgetWritebackSheet budgetWritebackWorksheet
Application.DisplayAlerts = True