Purpose
Imports the provided Generic Writeback worksheet.
See Introduction to Velixo's VBA functions for general usage information.
Syntax
objVelixo.WritebackWorksheet 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 GL 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 genWritebackWorksheet As Excel.Worksheet
Dim currentWorkbook As Excel.Workbook
Set velixoObj = CreateObject("Velixo.Reports.Vba")
Application.DisplayAlerts = False
Set currentWorkbook = Application.ActiveWorkbook
Set genWritebackWorksheet = currentWorkbook.Worksheets("Writeback")
velixoObj.WritebackWorksheet genWritebackWorksheet
Application.DisplayAlerts = True