error trap

  • Thread starter Thread starter Rhonda
  • Start date Start date
R

Rhonda

Hi,

I also need some sort of error trapping here. If the
person missed doing the refresh at 24th and, for example
opened it on the 28th, I need the refresh to execute.
Somehow it has to check if it had refreshed on the 24th
and if not, and it's still within the same month, I need
it to be able to refresh then. But not anymore for the
rest of that month. I need help!!!








Private Sub Refresh_Button_Click()
If Date = DateSerial(Year(Date), Month(Date), 24)
Then
MsgBox "This is the 24th day of the Month. Your
data will be updated."

' RefreshMeters Macro
' Macro recorded 30/09/2003 by rhocarit
'
' Keyboard Shortcut: Ctrl+a
'
ActiveWorkbook.RefreshAll

Else
MsgBox "This is NOT the 24th day of the Month.
Your data has NOT been updated."
End If
End Sub
 
Rhonda,

The easiest way is to have the refresh code put a date stamp in a cell.
Than you can check that cell to see when it was updated.

Range("A1") = Date
 
Back
Top