Skip to content

Module: Mod Export to Excel

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

Dependencies

Module Dependencies: - Actdatabase - PillRecSet - CompRecSet - QryDef - DetRecSet - RecSet - MonRecSet

Tables Accessed: - End - within - Entrepreneurs - Entrepreneur - Temp - the - Principal - Tab - Report - CompRecSet - tab - Qry - RecSet

Forms Referenced: - Frm

External References: - Excel.Application

Procedures

ExportBookingComplianceByDeliveryLocationToExcel

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

Calls: QueryDefs, Fields, Workbooks, Cells, Worksheets, CreateObject, ExportBookingComplianceByDeliveryLocationToExcel, Eval, Columns, Submitted (+1 more)

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

ExportFinanceSummaryToExcel

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

Calls: Cumulative, ignition, Average, Fields, Workbooks, Cells, Worksheets, ExportFinanceSummaryToExcel, CreateObject, Columns (+1 more)

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

ExportFinanceDetailToExcel

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

Calls: Fields, Workbooks, Cells, Worksheets, ExportFinanceDetailToExcel, Until, CreateObject, Columns, OpenRecordset

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

ExportPrincipalSpendByDeliveryLocationToExcel

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

Calls: QueryDefs, Fields, Workbooks, Cells, Worksheets, CreateObject, Eval, Columns, OpenRecordset, ExportPrincipalSpendByDeliveryLocationToExcel

Complexity Notes: - ⚠️ Contains GoTo statements

ExportPrincipalSpendByCompanyToExcel

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

Calls: QueryDefs, Fields, OpenRecordset, Cells, Workbooks, Worksheets, CreateObject, Columns, Eval, ExportPrincipalSpendByCompanyToExcel

Complexity Notes: - ⚠️ Contains GoTo statements

ExportBookingComplianceByCompanyToExcel

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

Calls: Fields, ExportBookingComplianceByCompanyToExcel, Workbooks, Cells, Worksheets, Until, CreateObject, DateAdd, Columns, OpenRecordset

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

ExportPrincipalSpendByPrincipalCompanyOneMonthToExcel

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

Calls: QueryDefs, Fields, ExportPrincipalSpendByPrincipalCompanyOneMonthToExcel, Cells, Workbooks, Worksheets, CreateObject, Eval, Columns, OpenRecordset

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

ExportPrincipalSpendTrackingToExcel

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

Calls: ExportPrincipalSpendTrackingToExcel, Fields, Year, Workbooks, Cells, Column, Worksheets, Month, CreateObject, DateAdd (+2 more)

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

ExportPrincipalSpendByPrincipalYTDToExcel

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

Calls: MonthName, QueryDefs, Fields, Workbooks, Cells, ExportPrincipalSpendByPrincipalYTDToExcel, Worksheets, CreateObject, Eval, Columns (+1 more)

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

ExportSDMOpalShiftReportToExcel

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

Calls: QueryDefs, Fields, Workbooks, Cells, Worksheets, ExportSDMOpalShiftReportToExcel, CreateObject, Eval, Columns, OpenRecordset

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

ExportBookkeeperTrackerToExcel

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

Calls: QueryDefs, Columns, Fields, Workbooks, Cells, Worksheets, CreateObject, Eval, ExportBookkeeperTrackerToExcel, OpenRecordset

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

ExportPrincipalProjectsPurchasedEDvsSDToExcel

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

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

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

ExportESDReporttoExcel

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

Calls: Sponsored, QueryDefs, Entrepreneur, Fields, Year, Workbooks, Cells, Int, Column, DateDiff (+8 more)

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

TestIt

Type: Public Sub
Lines: 3

Calls: ExportESDReporttoExcel, TestIt