Integrating Excel and C#

How to do the same stuff in Excel and C#

Monday, September 5, 2016

modGlobals

modGlobals


Option Compare Database
Option Explicit
#Const DEBUG_MODE = 1
#Const PROD_MODE = 0
#Const APP_MODE = DEBUG_MODE
Public Const msMODULE As String = "modGlobals"

Public Enum ACTION_MODE
    navigate = 0
    AddNew = 1
    Update
    Delete
    cancellation
End Enum

Public Enum MaintenanceTables
    TBL_TalentType = 1
    TBL_JobStatus
    TBL_Language
End Enum

Public Enum FeedHistoryDetail
    ID = 0
    COB_Date
    StartTime
    EndTime
    RecordCount
    ElapsedTime
    DateCreated
    UserCreated
    DateModified
    UserModified
    FeedStatus
End Enum


Public Enum DailyWorkDetail
    ID = 0
    ClientID
    ClientName
    DailyWorkStatus
    ApprovedDate
    Approver
    CollateralBalance
    EquityBalance
    DailyWorkCalculationID
    IMRequirement
End Enum

Public Enum SentDailyWork
    ID = 0
    BatchID
    BatchTime
    ClientID
    ClientName
    Status
    DailyWorkId
End Enum


Public Enum SecurityUserQueue
    ID = 0
    EmployeeName
    UserAccessLevel
    UserAccessLevelDescription
    TransactionType
    TransactionTypeDescription
    ApprovedDate
    Approver
    DateCreated
    UserCreated
    DateModified
    UserModified
End Enum
    
Public Enum DailyWorkStatus
    Pending = 1
    Approved
    HoldBack
    AwaitingApproval
End Enum


' what is this used for
Public Enum SentDailyWorkStatus
    Pending = 1
    Approved
    HoldBack
    AwaitingApproval    'new
    All
End Enum

Public Enum SentDailyWorkFilter
    Pending = 1
    Approved
    HoldBack
    AwaitingApproval    'new
    Sent
    All
End Enum

Public Enum UserRole
    ReadOnly = 1
    System = 2
    NewBusiness = 3
    MarginAnalyst = 4
    MarginAnalystsSupervisor = 5
    Admin = 8
    SuperAdmin = 10
End Enum

Public Enum SecurityObject
    FeedAutoImport = 1
    FeedManualImport
    ClientMaintain
    ClientApprover
    StatementHoldBack
    StatementApproval
    SecurityMaintain
    SecurityApprove
    StatementAwaitingApproval
    BulkSend
End Enum
    
Public Enum QBEReport
    QBEReportId = 0
    reportname
    Text
    AlphaCriteria
    DateCriteria
    TableName
    PrimarySort
    Group
End Enum
    
    
Public Enum MailClient
    OutLook = 1
    LotusNotes
End Enum

Public Enum TransactionType
    Add = 1
    Update
    Delete
End Enum

Public Enum TradeDetail
    [ID] = 0
    Row
    Underlying
    MaturityDate
    notational
    SettlementPrice
    PriorSettlementPrice
    AccruedCpn
    MTM
    ResetToPar
    InitialCoupon
    CPNSettlement
    [VMExcess_Defecit]
    [Todays Total VM Req]
    [TotalCashAdj]
End Enum

Public Enum CashMovementDetail
    [ID] = 0
    Amount
    DateCreated
    UserCreated
    DateModified
    UserModified
    TransactionType
End Enum

Public Enum DailyWorkCashMovementDetail
    ID = 0
    COB_Date
    Amount
    Approver
    ApprovedDate
    DateCreated
    UserCreated
    DateModified
    UserModified
    TransactionType
    ClientID
End Enum

Public Const ERR_MSG_REQUIRED_FIELD_MISSING As String = _
    "Required field.  Can't be blank or missing."
Public Const ERR_MSG_INVALID_START_DATE As String _
    = "Invalid Start Date or must be less than ending Date"
Public Const ERR_MSG_BLANK_NAME As String = "Required value -must supply a name"
Public Const ERR_MSG_NO_RIGHTS_TO_FUNCTION As String = "Not enough priveleges to run this command. " & _
    "Please contact system administrator for more assistance"

Public Const ERR_MSG_EXISTS_IN_QUEUE As String = "No need to try again because it is all ready in the queue of pending changes."
'=====================================================
Public Const APP_NAME As String = "ProductivityTool"
'Public APP_PATH As String
'Public APP_INPUT_PATH As String
'Public APP_OUTPUT_PATH As String


'Public Const APP_PATH As String = CurrentProject.Path
'Public Const APP_INPUT_PATH As String = AddBS(APP_PATH) & "Input"
'Public Const APP_OUTPUT_PATH As String = AddBS(APP_PATH) & "Output"

Public Const APP_LOCAL_APP_PATH  As String = "C:\My Documents\My App"
Public Const APP_LOCAL_INPUT_PATH As String = APP_LOCAL_APP_PATH & "\" & "Input"
Public Const APP_LOCAL_OUTPUT_PATH As String = APP_LOCAL_APP_PATH & "\" & "Output"


Public Const COMPANY_NAME As String = "Deutsche Bank AG"
'Public gbDEBUG_MODE As Boolean
Public gbApp_SetupOccurred As Boolean
Public Const MASK_DATE As String = "mm/dd/yyyy"
Public Const MASK_MONEY As String = "$#,##0.00;($#,##0.00)"
Public Const MASK_HOLDINGS As String = "#,##0;(#,##0)"
Public lngMyEmpID As Long
Public gstrUserName As String
'Public gUserAccessLevel As UserRole
Click here to Reply or Forward
0.97 GB (6%) of 15 GB used
Manage
Terms - Privacy
Last account activity: 0 minutes ago
Currently being used in 1 other location  Details
Bill DeCastro

Show details

at 7:38 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Web Designer

  • New York Web Design

Tags

  • A1 (1)
  • ADO (3)
  • ADO.NET (2)
  • After. SQL Server (1)
  • Application setup (1)
  • C# Excel PIA (2)
  • C# VBA (7)
  • cell (1)
  • Cells (2)
  • column (1)
  • Command (1)
  • Data Access (1)
  • DML (1)
  • ETL (1)
  • Excel PIA (1)
  • Excel Range (3)
  • Excel VBA (6)
  • Excel. Application (1)
  • Excel.Range (7)
  • formula (4)
  • Instead Of (1)
  • macro (3)
  • MS Access (2)
  • Name. ReferstoRange (1)
  • Names (1)
  • object (1)
  • Properties (1)
  • R1C1 (4)
  • Resize (1)
  • row (1)
  • stored procedure (1)
  • Trigger (1)
  • UDF (4)
  • variable (1)
  • WinAPI (4)
  • workbook (2)
  • worksheet (1)

Search This Blog

Archive

  • ▼  2016 (38)
    • ►  December (1)
    • ►  November (13)
    • ►  October (6)
    • ▼  September (17)
      • Using Upsert SQL query
      • ADODB recordset for MS Access Recordset property
      • Enterprise Error Management- Setup phase
      • Enterprise Error Management- Setup phase
      • Enterprise grade Error Management (Overview)
      • Sample SQL Script to Create table with Foreign Key...
      • Trips,Trick and Traps: Excel Form Control ListBox/...
      • Building COM DLLs in C# (Part I)
      • Upsizing from Access to SQL Server
      • Data Validation Finding required fields that are n...
      • Using ADO to get path to BackEnd table Option Com...
      • modMain
      • modGeneral
      • modApp
      • modAPI
      • modError
      • modGlobals
    • ►  April (1)
  • ►  2015 (17)
    • ►  June (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (10)
  • ►  2013 (10)
    • ►  October (4)
    • ►  September (5)
    • ►  August (1)
Dado Enterprises. Simple theme. Powered by Blogger.