Purpose
Imports the provided Project Budget Forecast worksheet.
See Introduction to Velixo's VBA functions for general usage information.
Syntax
VelixoObject.ImportProjectForecastSheet Worksheet
VelixoObject - a variable that represents an instance of the Velixo VBA functions class.
Parameters
Name | Description |
Worksheet | Required. An Excel.Worksheet value that provides the Project Forecast 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 Application.DisplayAlerts to True.
Example
Dim VelixoObject As Velixo_Reports.VBA
Dim ProjectForecastWritebackWorksheet As Excel.Worksheet
Dim CurrentWorkbook As Excel.Workbook
Set VelixoObject = CreateObject("Velixo.Reports.Vba")
Set CurrentWorkbook = Application.ActiveWorkbook
Set ProjectForecastWritebackWorksheet = currentWorkbook.Worksheets("Project Forecast Writeback")
Application.DisplayAlerts = False
VelixoObject.ImportProjectForecastSheet ProjectForecastWritebackWorksheet
Application.DisplayAlerts = True