Skip to content

Module: Mod Export Excel

Type: Standard
Lines of Code: 5438
Source: ms_access_files\purple\Modules\Mod Export Excel.bas

Dependencies

Module Dependencies: - RecSet - QryDef - SucRecSet - DetRecSet - EPRecSet - TblRecSet - Actdatabase - UserRecSet - CntRecSet

Tables Accessed: - DatabaseUsers - RowPtr - RecSet - Entrepreneur - Entrepreneurs - Qry - Sue - the - Temp

Forms Referenced: - Frm

External References: - Excel.Application

Procedures

ExportDetailedPrincipalToExcel

Type: Public Sub
Lines: 87

Calls: Cells, OpenRecordset, Eval, ExportDetailedPrincipalToExcel, Fields, Worksheets, QueryDefs, CreateObject

Complexity Notes: - ⚠️ Contains GoTo statements

ExportPrincipalSupplierListAndMarketingToExcel

Type: Public Sub
Lines: 467

Calls: Cells, OpenRecordset, Eval, ExportPrincipalSupplierListAndMarketingToExcel, Fields, Worksheets, QueryDefs, CreateObject

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

ExportRaizcorpPossibilitiesToExcel

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

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

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

ExportMarketingLeadsVersionTwoToExcel

Type: Public Sub
Lines: 95

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

Complexity Notes: - ⚠️ Contains GoTo statements

ExportMarketingLeadTypePrincipalAllocationToExcel

Type: Public Sub
Lines: 129

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

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

Export48HoursToExcel

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

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

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

ExportRAGToExcel

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

Calls: Columns, Cells, OpenRecordset, RAG, Fields, Worksheets, approval, Workbooks, ExportRAGToExcel, CreateObject (+1 more)

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

ExportPartnerEliteToExcel

Type: Public Sub
Lines: 269

Calls: Columns, Cells, OpenRecordset, Rows, Eval, ExportPartnerEliteToExcel, Fields, Worksheets, QueryDefs, CreateObject

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

ExportRecommendedPrincipalProjectAllocationToExcel

Type: Public Sub
Lines: 153

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

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

ExportPrincipalProjectAllocationbyEntrepreneurToExcel

Type: Public Sub
Lines: 110

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

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

ExportOpalPrincipalProjectsToExcel

Type: Public Sub
Lines: 109

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

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

ExportOpalRaizcorpossiblesToExcel

Type: Public Sub
Lines: 148

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

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

ExportAvgDaysPipelineTrendbyDistModel

Type: Public Sub
Lines: 187

Calls: Columns, Year, OpenRecordset, Month, Cells, Eval, DateAdd, ExportAvgDaysPipelineTrendbyDistModel, Fields, Worksheets (+3 more)

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

ExportOpalPrincipalProjectSummarytoExcel

Type: Public Sub
Lines: 321

Calls: Columns, Cells, OpenRecordset, Eval, ending, Fields, Worksheets, QueryDefs, Location, ExportOpalPrincipalProjectSummarytoExcel (+2 more)

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

ExportPurplePanelistSummaryToExcel

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

Calls: Columns, Cells, OpenRecordset, Eval, Worksheets, Attended, Fields, ExportPurplePanelistSummaryToExcel, QueryDefs, Workbooks (+1 more)

Complexity Notes: - ⚠️ Contains GoTo statements

ExportWorkshopAttendanceRegisterToExcel

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

Calls: Columns, Cells, OpenRecordset, Rows, Eval, Borders, ExportWorkshopAttendanceRegisterToExcel, Fields, Worksheets, QueryDefs (+3 more)

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

ExportEntrepreneursInvoiceRequestedToExcel

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

Calls: Columns, Range, Cells, OpenRecordset, Fields, Worksheets, DateDiff, Workbooks, CreateObject, ExportEntrepreneursInvoiceRequestedToExcel

Complexity Notes: - ⚠️ Contains GoTo statements

ExportMoreThan3FollowUpToExcel

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

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

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

ExportMarketingPreUnqualifiedLeadsToExcel

Type: Public Sub
Lines: 90

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

Complexity Notes: - ⚠️ Contains GoTo statements

ExportMarketingEOItoPassedPanelToExcel

Type: Public Sub
Lines: 80

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

Complexity Notes: - ⚠️ Contains GoTo statements

ExportTerminationAnalysisDataToExcel

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

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

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

ExportQuartzLeadsbyPhaseToExcel

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

Calls: Columns, ExportQuartzLeadsbyPhaseToExcel, Cells, OpenRecordset, Approval, Fields, Worksheets, Workbooks, CreateObject

Complexity Notes: - ⚠️ Contains GoTo statements

ExportPercentDropoffAfterFristMeetingToExcel

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

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

Complexity Notes: - ⚠️ Contains GoTo statements

ExportBlueHearEmailNotSentToExcel

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

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

Complexity Notes: - ⚠️ Contains GoTo statements

ExportAverageDaysPerStepToExcel

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

Calls: Columns, Round, Cells, OpenRecordset, Fields, ExportAverageDaysPerStepToExcel, Worksheets, Workbooks, CreateObject

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

ExportPurplePanelResultsToExcel

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

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

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

ExportPreviousStepTerminatedReadyAllocated

Type: Public Sub
Lines: 184

Calls: Columns, Year, OpenRecordset, Month, Cells, ExportPreviousStepTerminatedReadyAllocated, Eval, DateAdd, Fields, Worksheets (+3 more)

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

ExportCompanyProfileMergeToExcel

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

Calls: Columns, Cells, OpenRecordset, ExportCompanyProfileMergeToExcel, Fields, Worksheets, Entrepreneur, Workbooks, CreateObject

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

SaveIt

Type: Public Sub
Lines: 3

Calls: SaveIt