Timer for Sheet Refresh every 15 minutes

[remeng]

Hi all,

I am trying to create a 15 minute refresh event for an excel sheet. I have looked at the Timer function and am a little confused as to how to use it to create the operation. I understand that the timer can really only go up to 1 minute. What I would like to do is count up to 15 every 1 minute then have the page refresh.


here is what I have so far. I know it is really basic and not even close to complete.

Sub RefreshInventory()
Dim refresh_sheet, n, t

n = 0 'Count Intervals

If n < 15 Then

n = n + 1

'Timer function for 1 minute goes here?

Else
ActiveWorkbook.RefreshAll 'Refresh Command for "DATA" sheet
n = 0 'After this I want the entire cycle to start again

End If

Run RefreshInventory()

End Sub

Thank you for the help!

Mike

 

[remeng]

Please disregard this. I was able to solve this by using the refresh all properties under the data tab.

Thank you

 

[SkipVought]

Is this VBA...forum707?

If so, check out the Application.OnTime method in Excel VBA Editor Help.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}