Module: Mod Export to Excel

Type: Standard
Lines of Code: 1901
Source: ms_access_files\ruby\Modules\Mod Export to Excel.bas

Dependencies

Module Dependencies: - RecSet - QryDef - Actdatabase

Tables Accessed: - the

External References: - Excel.Application

Procedures

ExportTheEmployeeListToExcel

Type: Public Sub
Lines: 126

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, ExportTheEmployeeListToExcel, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (126 lines)

ExportOpalReportsToExcel

Type: Public Sub
Lines: 622

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, ExportOpalReportsToExcel, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ High branching (12 If statements) - ⚠️ Large procedure (622 lines)

ExportLeadSummaryToExcel

Type: Public Sub
Lines: 128
Parameters: FromAuto As Boolean, Optional TheFileName As String

Calls: CreateObject, Workbooks, Fields, Cells, Columns, ExportLeadSummaryToExcel, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (128 lines)

ExportTheISPExceptionToExcel

Type: Public Sub
Lines: 86

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, ExportTheISPExceptionToExcel, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements

ExportTheISPSummaryToExcel

Type: Public Sub
Lines: 89

Calls: CreateObject, QueryDefs, ExportTheISPSummaryToExcel, Fields, Cells, Columns, Eval, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements

ExportTheISPPerformanceReporttoExcel

Type: Public Sub
Lines: 94

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, ExportTheISPPerformanceReporttoExcel, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements

ExportTheQualificationsReporttoExcel

Type: Public Sub
Lines: 97

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, OpenRecordset, ExportTheQualificationsReporttoExcel, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements

ExportTheMeGRAPHReporttoExcel

Type: Public Sub
Lines: 113

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, OpenRecordset, ExportTheMeGRAPHReporttoExcel, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (113 lines)

ExportTheCareReporttoExcel

Type: Public Sub
Lines: 109

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, OpenRecordset, ExportTheCareReporttoExcel, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (109 lines)

ExportTheAwardsAndRecognitionReporttoExcel

Type: Public Sub
Lines: 109

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, OpenRecordset, ExportTheAwardsAndRecognitionReporttoExcel, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (109 lines)

ExportTheNewStartsReporttoExcel

Type: Public Sub
Lines: 101

Calls: ExportTheNewStartsReporttoExcel, CreateObject, QueryDefs, Fields, Cells, Columns, Eval, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (101 lines)

ExportTheExitsReporttoExcel

Type: Public Sub
Lines: 96

Calls: CreateObject, QueryDefs, Fields, Cells, Columns, Eval, ExportTheExitsReporttoExcel, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements

ExportTheTimeToFillReporttoExcel

Type: Public Sub
Lines: 115

Calls: CreateObject, QueryDefs, ExportTheTimeToFillReporttoExcel, Cells, Fields, Columns, Eval, OpenRecordset, Worksheets

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (115 lines)