Skip to content

Module: Mod Export Excel

Type: Standard
Lines of Code: 5938
Source: ms_access_files\garnet\Modules\Mod Export Excel.bas

Dependencies

Module Dependencies: - EPRecSet - EntRecSet - ProdRecSet - QryRecSet - RecSet - QryDef - Actdatabase - OpsRecSet - SourcedRecSet - ProjRecSet

Tables Accessed: - Principal - Qry - Distance - QryRecSet - vwGarnetRptAllocationExportNonGraduateCompanies - by - Last - vwGarnetRptAllocationExportOnProgrammeandOthersCompanies - SubQry - Temp - vwGarnetRptAllocationExportGraduatedCompanies - account - Prosperator - Entrepreneur - Beacon - the

Forms Referenced: - Frm

External References: - Excel.Application

Procedures

ExportRaizcorpPossibilitiesToExcel

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

Calls: Nz, ExportRaizcorpPossibilitiesToExcel, Cells, OpenRecordset, Columns, WHERE, Worksheets, Workbooks, CreateObject, Fields

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

ExportPrincipalProjectTotalsByDeliveryMethodExcel

Type: Public Sub
Lines: 89

Calls: ExportPrincipalProjectTotalsByDeliveryMethodExcel, Round, Nz, Cells, OpenRecordset, Columns, Worksheets, CreateObject, Fields, Allocated

Complexity Notes: - ⚠️ Contains GoTo statements

ExportCompanyTotalsByDeliveryMethodExcel

Type: Public Sub
Lines: 94

Calls: Nz, Cells, OpenRecordset, Columns, Worksheets, ExportCompanyTotalsByDeliveryMethodExcel, CreateObject, Fields, Allocated

Complexity Notes: - ⚠️ Contains GoTo statements

ExportPrincipalProjectProductTotalsByDeliveryLocationExcel

Type: Public Sub
Lines: 131

Calls: SUM, Round, Nz, Cells, OpenRecordset, Columns, Programme, ExportPrincipalProjectProductTotalsByDeliveryLocationExcel, Worksheets, CreateObject (+1 more)

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

ExportPrincipalProjectAllocationToExcel

Type: Public Sub
Lines: 270

Calls: Nz, Cells, OpenRecordset, Sponsorship, Columns, Worksheets, CreateObject, Fields, ExportPrincipalProjectAllocationToExcel

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

ExportPrincipalProjectAllocationFinanceToExcel

Type: Public Sub
Lines: 1006

Calls: ExportPrincipalProjectAllocationFinanceToExcel, Nz, Cells, OpenRecordset, Columns, Worksheets, CreateObject, Fields, Nongraduate

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

ExportRAGToExcel

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

Calls: ExportRAGToExcel, Nz, Cells, OpenRecordset, RAG, Columns, Column, approval, Worksheets, Workbooks (+2 more)

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

ExportActiveEntrepreneursDeliveryMethod

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

Calls: ExportActiveEntrepreneursDeliveryMethod, Nz, Cells, OpenRecordset, Columns, Worksheets, Workbooks, CreateObject, Fields

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

ExportNewAllocationToExcel

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

Calls: Nz, Cells, OpenRecordset, Columns, Worksheets, Workbooks, CreateObject, Fields, ExportNewAllocationToExcel

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

ExportActiveEntrepreneurEmailReportToExcel

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

Calls: Nz, Cells, OpenRecordset, ExportActiveEntrepreneurEmailReportToExcel, Columns, Worksheets, Workbooks, CreateObject, Fields

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

ExportDeliveryVsExitedSummaryToExcel

Type: Public Sub
Lines: 82

Calls: ExportDeliveryVsExitedSummaryToExcel, Nz, Cells, OpenRecordset, Columns, Worksheets, CreateObject, Fields, Eval, QueryDefs

Complexity Notes: - ⚠️ Contains GoTo statements

ExportPrincipalQuarterlyReportsToExcel

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

Calls: Nz, Cells, ExportPrincipalQuarterlyReportsToExcel, OpenRecordset, Columns, Worksheets, Workbooks, CreateObject, Fields

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

ExportCompaniesLeftProgrammeToExcel

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

Calls: Nz, Cells, OpenRecordset, Columns, ExportCompaniesLeftProgrammeToExcel, Worksheets, Workbooks, CreateObject, Fields, Eval (+1 more)

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

ExportCompanyNeedsReplacementToExcel

Type: Public Sub
Lines: 106

Calls: Nz, Cells, OpenRecordset, ExportCompanyNeedsReplacementToExcel, Columns, Worksheets, CreateObject, Fields

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

ExportSummarisedDeferredIncomeExcel

Type: Public Sub
Lines: 158

Calls: Nz, Cells, OpenRecordset, Sponsorship, Columns, Worksheets, CreateObject, Fields, ExportSummarisedDeferredIncomeExcel

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

ExportPreBillingExceptionReportToExcel

Type: Public Sub
Lines: 112

Calls: Nz, Cells, OpenRecordset, ExportPreBillingExceptionReportToExcel, Columns, Worksheets, CreateObject, Fields

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

ExportCompaniesStartedProgrammeToExcel

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

Calls: Nz, Cells, OpenRecordset, ExportCompaniesStartedProgrammeToExcel, Columns, Worksheets, Workbooks, CreateObject, Fields, Eval (+1 more)

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

ExportCompaniesAllocatedToExcel

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

Calls: Nz, Cells, OpenRecordset, Columns, ExportCompaniesAllocatedToExcel, Worksheets, Workbooks, CreateObject, Fields, Eval (+1 more)

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

ExportCompaniesNeedToBeAllocatedToExcel

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

Calls: Nz, Cells, OpenRecordset, Columns, ExportCompaniesNeedToBeAllocatedToExcel, Worksheets, Workbooks, CreateObject, Fields

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

ExportPrincipalProjectFinanceAuditToExcel

Type: Public Sub
Lines: 979

Calls: ExportPrincipalProjectFinanceAuditToExcel, Nz, Cells, OpenRecordset, Nongraduate, Columns, Worksheets, CreateObject, Fields, Eval (+1 more)

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

ExportNumberCompaniesIgnitedbyProductToExcel

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

Calls: Nz, Cells, OpenRecordset, Columns, Worksheets, Workbooks, CreateObject, Fields, ExportNumberCompaniesIgnitedbyProductToExcel, Eval (+1 more)

Complexity Notes: - ⚠️ Contains GoTo statements

Nz

Type: Public Function
Lines: 7
Parameters: value, replacement As Variant
Returns: Variant

Calls: Nz