Module: Mod Export Excel

Type: Standard
Lines of Code: 693
Source: ms_access_files\topaz\Modules\Mod Export Excel.bas

Dependencies

Module Dependencies: - Actdatabase - QryDef - RecSet

Tables Accessed: - the

External References: - Excel.Application

Type: Public Sub
Lines: 95

Calls: QueryDefs, Qualified, Columns, CreateObject, Fields, OpenRecordset, ExportMarketingLeadsVersionTwoToExcel, Worksheets, Cells, Eval

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Public Sub
Lines: 90

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

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Public Sub
Lines: 80

Calls: ExportMarketingEOItoPassedPanelToExcel, Columns, CreateObject, Fields, OpenRecordset, Worksheets, Cells

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Public Sub
Lines: 129

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

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

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

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

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

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

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

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