Thanks for your prompt response. Yes, I did change the values you asked me to do. I have attached the sample excel sheet and the code below.
Const strWorkBook As String = "Count0To12Hr.xls" 'The name of the attached workbook
Const strSheet As String = "Count0To12Hr" 'The name of the worksheet to process
Const strCell As String = "E2" 'The cell to process
Const iCount As Integer = 25 'The threshold value of the above cell
Const strMessage As String = "count for today dropped by 20 percent from last weekday"
|