all my code is listed below. for all ws's, forms an modules. I need to know how to be able to open up a new workbook once the month changes. so that all of february is with february and all of march is in march etc...
[CODE=vb]Option Explicit
Private Sub cmdRJFH_Click()
Dim iRow As Long
Dim myDate As Date, newDate As Date, oldSheet As String, newSheet As String
Dim ws As Worksheet
...
stingerj
Last Activity: Feb 26 '08, 03:26 PM
Joined: Feb 14 '08
Location:
-
Start a new worksheet per month
-
finding the same occurrence in the database more than twice....
my code only allows me to check for two occurrences of the same jobname and thats all, But I need to have it check for more than two occurrences wthin the same month. on the same ws.
here is the code i have so far.
[CODE=vb]Dim Found As Range, temp As Range
Set temp = ws.Columns(2).F ind(what:=JobNa me)
If temp Is Nothing Then
MsgBox JobName & " Not found"
Exit Sub... -
Sending an email or phone alert
I need to know how to send an email to somebody if an excell worksheet say cell c11 is red and the time is 01:10am. If not an email than what about a text message to their phone.. Something to alert this person that something is late and needs to be looked at from this worksheet.
No activity results to display